DBA Data[Home] [Help]

APPS.AHL_PC_HEADER_PVT dependencies on AHL_PC_NODES_VL

Line 799: FROM AHL_PC_NODES_VL AHNO

795: AHNO.ATTRIBUTE12,
796: AHNO.ATTRIBUTE13,
797: AHNO.ATTRIBUTE14,
798: AHNO.ATTRIBUTE15
799: FROM AHL_PC_NODES_VL AHNO
800: WHERE AHNO.PC_HEADER_ID = p_header_id
801: UNION
802: SELECT DISTINCT AHS.ROWID ROW_ID,
803: AHS.PC_ASSOCIATION_ID PC_NODE_ID,

Line 1669: FROM AHL_PC_NODES_VL AHNO

1665: AHNO.ATTRIBUTE12,
1666: AHNO.ATTRIBUTE13,
1667: AHNO.ATTRIBUTE14,
1668: AHNO.ATTRIBUTE15
1669: FROM AHL_PC_NODES_VL AHNO
1670: WHERE AHNO.PC_HEADER_ID = p_header_id
1671: UNION
1672: SELECT DISTINCT AHS.ROWID ROW_ID,
1673: AHS.PC_ASSOCIATION_ID PC_NODE_ID,

Line 2316: FROM AHL_PC_NODES_VL AHNO

2312: AHNO.ATTRIBUTE12,
2313: AHNO.ATTRIBUTE13,
2314: AHNO.ATTRIBUTE14,
2315: AHNO.ATTRIBUTE15
2316: FROM AHL_PC_NODES_VL AHNO
2317: WHERE AHNO.PC_HEADER_ID = p_header_id
2318: UNION
2319: SELECT AHS.PC_ASSOCIATION_ID PC_NODE_ID,
2320: NODE.PC_HEADER_ID,

Line 2426: FROM AHL_PC_NODES_VL AHNO

2422: AHNO.DESCRIPTION,
2423: 'N' NODE_TYPE,
2424: 0 UNIT_ITEM_ID,
2425: 0 INVENTORY_ORG_ID
2426: FROM AHL_PC_NODES_VL AHNO
2427: UNION
2428: SELECT AHS.PC_ASSOCIATION_ID PC_NODE_ID,
2429: AHS.OBJECT_VERSION_NUMBER,
2430: NODE.PC_HEADER_ID,