APPS.EAM_CAP_MAIN_COST_PVT dependencies on CSI_ITEM_INSTANCES

Line 41: FROM csi_item_instances cii,

37: pc_org_id IN NUMBER,
38: pc_inventory_item_id IN NUMBER) IS
39: SELECT cia.fa_asset_id,
40: cia.fa_book_type_code
41: FROM csi_item_instances cii,
42: csi_i_assets cia
43: WHERE cii.instance_id = cia.instance_id
44: AND cii.inventory_item_id = NVL(pc_asset_group_id,pc_rebuild_item_id)
45: AND cii.instance_number = NVL(pc_asset_number, pc_rebuild_serial_number)