APPS.AHL_PC_HEADER_PVT dependencies on CSI_ITEM_INSTANCES

Line 850: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

846: AHS.ATTRIBUTE13,
847: AHS.ATTRIBUTE14,
848: AHS.ATTRIBUTE15
849: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
850: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
851: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
852: WHERE p_copy_assos_flag = 'Y'
853: AND NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
854: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID

Line 1793: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

1789: AHS.ATTRIBUTE13,
1790: AHS.ATTRIBUTE14,
1791: AHS.ATTRIBUTE15
1792: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
1793: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
1794: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
1795: WHERE NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
1796: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID
1797: AND HEADER.PC_HEADER_ID = p_header_id

Line 2506: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

2502: AHS.ATTRIBUTE13,
2503: AHS.ATTRIBUTE14,
2504: AHS.ATTRIBUTE15
2505: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2506: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2507: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2508: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2509: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2510: AND NODE.PC_HEADER_ID = p_header_id

Line 2595: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

2591: AHS.ASSOCIATION_TYPE_FLAG NODE_TYPE,
2592: AHS.UNIT_ITEM_ID,
2593: AHS.INVENTORY_ORG_ID
2594: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2595: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2596: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2597: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2598: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2599: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID