DBA Data[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on AHL_PC_NODES_VL

Line 806: FROM AHL_PC_NODES_VL AHNO

802: AHNO.ATTRIBUTE12,
803: AHNO.ATTRIBUTE13,
804: AHNO.ATTRIBUTE14,
805: AHNO.ATTRIBUTE15
806: FROM AHL_PC_NODES_VL AHNO
807: WHERE AHNO.PC_HEADER_ID = p_header_id
808: START WITH PARENT_NODE_ID = 0
809: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID;
810:

Line 1748: FROM AHL_PC_NODES_VL AHNO

1744: AHNO.ATTRIBUTE12,
1745: AHNO.ATTRIBUTE13,
1746: AHNO.ATTRIBUTE14,
1747: AHNO.ATTRIBUTE15
1748: FROM AHL_PC_NODES_VL AHNO
1749: WHERE AHNO.PC_HEADER_ID = p_header_id
1750: START WITH PARENT_NODE_ID = 0
1751: CONNECT BY PRIOR PC_NODE_ID = PARENT_NODE_ID;
1752:

Line 2472: FROM AHL_PC_NODES_VL AHNO

2468: AHNO.ATTRIBUTE12,
2469: AHNO.ATTRIBUTE13,
2470: AHNO.ATTRIBUTE14,
2471: AHNO.ATTRIBUTE15
2472: FROM AHL_PC_NODES_VL AHNO
2473: WHERE AHNO.PC_HEADER_ID = p_header_id
2474: START WITH AHNO.PARENT_NODE_ID = 0
2475: CONNECT BY PRIOR AHNO.PC_NODE_ID = AHNO.PARENT_NODE_ID;
2476:

Line 2582: FROM AHL_PC_NODES_VL AHNO

2578: AHNO.DESCRIPTION,
2579: 'N' NODE_TYPE,
2580: 0 UNIT_ITEM_ID,
2581: 0 INVENTORY_ORG_ID
2582: FROM AHL_PC_NODES_VL AHNO
2583: UNION
2584: SELECT AHS.PC_ASSOCIATION_ID PC_NODE_ID,
2585: AHS.OBJECT_VERSION_NUMBER,
2586: NODE.PC_HEADER_ID,