DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on AHL_PC_ASSOCIATIONS

Line 5592: from ahl_pc_associations unit

5588: FROM ahl_pc_nodes_b B
5589: WHERE B.pc_node_id = EFF.pc_node_id
5590: START WITH B.pc_node_id
5591: IN (select pc_node_id
5592: from ahl_pc_associations unit
5593: where unit.association_type_flag = 'U'
5594: and unit.unit_item_id = UCH.unit_config_header_id)
5595: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id),
5596: 1) > 0

Line 5605: from ahl_pc_associations itm, csi_item_instances csi

5601: FROM ahl_pc_nodes_b B
5602: WHERE B.pc_node_id = EFF.pc_node_id
5603: START WITH B.pc_node_id
5604: IN (select pc_node_id
5605: from ahl_pc_associations itm, csi_item_instances csi
5606: where itm.association_type_flag = 'I'
5607: and itm.unit_item_id = csi.inventory_item_id
5608: and csi.instance_id = UCH.csi_item_instance_id)
5609: CONNECT BY B.pc_node_id = PRIOR B.parent_node_id),