Friday, April 24, 2020

Account Hierarchy query In Fusion Cloud


SELECT TREE_CODE, PARENT_TREE_NODE_ID, PK1_START_VALUE
FROM FND_TREE_NODE
WHERE TREE_STRUCTURE_CODE = 'HIERARCHY NAME HERE'

IF PARENT_TREE_NODE_ID is NULL that means it is the parent code or child code dose not belong to any parent.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SOAP Payload to get Sales Order Details Oracle cloud 20a (Oracle Fusion Sales order details)

Use SOAP UI --------------------------------------------------------------------------------------------------- Service WSDL URL:  https://X...