DBA Data[Home] [Help]

APPS.EAM_CAP_MAIN_COST_PVT dependencies on CSI_I_ASSETS

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)

Line 119: -- Get the asset information from CSI_I_ASSETS

115: l_asset_number := NULL;
116: l_in_use_flag := NULL;
117: l_add_to_asset := TRUE;
118: l_post_asset_category_id := NULL;
119: -- Get the asset information from CSI_I_ASSETS
120: OPEN c_inst_asset_info(p_eam_wo_bills_tbl(i).asset_group_id,
121: p_eam_wo_bills_tbl(i).rebuild_item_id,
122: p_eam_wo_bills_tbl(i).asset_number,
123: p_eam_wo_bills_tbl(i).rebuild_serial_number,