APPS.AHL_PC_HEADER_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 839: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

835: AHS.ATTRIBUTE13,
836: AHS.ATTRIBUTE14,
837: AHS.ATTRIBUTE15
838: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
839: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
840: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
841: WHERE p_copy_assos_flag = 'Y'
842: AND NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
843: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID

Line 1709: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

1705: AHS.ATTRIBUTE13,
1706: AHS.ATTRIBUTE14,
1707: AHS.ATTRIBUTE15
1708: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
1709: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
1710: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
1711: WHERE NODE.PC_HEADER_ID = HEADER.PC_HEADER_ID
1712: AND NODE.PC_NODE_ID = AHS.PC_NODE_ID
1713: AND HEADER.PC_HEADER_ID = p_header_id

Line 2346: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

2342: AHS.ATTRIBUTE13,
2343: AHS.ATTRIBUTE14,
2344: AHS.ATTRIBUTE15
2345: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2346: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2347: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2348: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2349: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2350: AND NODE.PC_HEADER_ID = p_header_id

Line 2439: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,

2435: AHS.ASSOCIATION_TYPE_FLAG NODE_TYPE,
2436: AHS.UNIT_ITEM_ID,
2437: AHS.INVENTORY_ORG_ID
2438: FROM AHL_PC_ASSOCIATIONS AHS, AHL_UNIT_CONFIG_HEADERS UNIT,
2439: CSI_ITEM_INSTANCES CSI, MTL_SYSTEM_ITEMS_KFV MTL,
2440: AHL_PC_NODES_B NODE, AHL_PC_HEADERS_B HEADER
2441: WHERE NODE.PC_NODE_ID = AHS.PC_NODE_ID
2442: AND HEADER.PC_HEADER_ID = NODE.PC_HEADER_ID
2443: AND UNIT.UNIT_CONFIG_HEADER_ID(+) = AHS.UNIT_ITEM_ID