APPS.EAM_CAP_MAIN_COST_PVT dependencies on WIP_DISCRETE_JOBS

Line 48: csi_i_assets cia, wip_discrete_jobs wdj

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
52: AND cii.inventory_item_id = NVL(pc_rebuild_item_id, pc_asset_group_id)