APPS.EAM_CAP_MAIN_COST_PVT dependencies on CSI_ITEM_INSTANCES

Line 47: FROM csi_item_instances cii,

43: pc_inventory_item_id IN NUMBER,
44: pc_wip_entity_id IN NUMBER) IS -- added wip ID prmt for bug 15877819
45: SELECT cia.fa_asset_id,
46: cia.fa_book_type_code
47: FROM csi_item_instances cii,
48: csi_i_assets cia, wip_discrete_jobs wdj
49: WHERE cii.instance_id = cia.instance_id
50: AND wdj.maintenance_object_id = cii.instance_id
51: AND wdj.wip_entity_id = pc_wip_entity_id