APPS.AHL_UTIL_PC_PKG dependencies on CSI_ITEM_INSTANCES

Line 105: FROM csi_item_instances

101: CONNECT BY parent_node_id = PRIOR pc_node_id
102: START WITH pc_node_id = p_pc_node_id)
103: AND unit_item_id in (
104: SELECT inventory_item_id
105: FROM csi_item_instances
106: WHERE Instance_ID = p_Item_Instance_ID)
107: AND association_type_flag='P';
108:
109: l_dummy VARCHAR2(100);

Line 214: CSI_ITEM_INSTANCES CSI,

210: SELECT DISTINCT
211: UNIT.UNIT_CONFIG_HEADER_ID
212: FROM
213: AHL_UNIT_CONFIG_HEADERS UNIT,
214: CSI_ITEM_INSTANCES CSI,
215: MTL_SYSTEM_ITEMS_KFV MTL,
216: AHL_PC_HEADERS_B HEADER
217: WHERE
218: UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND

Line 245: CSI_ITEM_INSTANCES CSI,

241: SELECT DISTINCT
242: UNIT.UNIT_CONFIG_HEADER_ID
243: FROM
244: AHL_UNIT_CONFIG_HEADERS UNIT,
245: CSI_ITEM_INSTANCES CSI,
246: MTL_SYSTEM_ITEMS_KFV MTL,
247: AHL_PC_HEADERS_B HEADER
248: WHERE
249: UNIT.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID AND