[Home] [Help]
143: oap.period_num,
144: oap.period_year,
145: (cdv.base_transaction_value) value
146: FROM cst_distribution_lite_v cdv, org_acct_periods oap, wip_discrete_jobs wdj,
147: wip_eam_parameters ep, mfg_lookups mf
148: WHERE ep.organization_id = cdv.organization_id
149: and cdv.wip_entity_id = wdj.wip_entity_id
150: and cdv.organization_id = wdj.organization_id
151: and cdv.operation_seq_num is null
224: l_stmt_num := 20;
225:
226: SELECT def_eam_cost_element_id
227: INTO l_def_eam_cost_element_id
228: FROM wip_eam_parameters
229: WHERE organization_id = p_organization_id;
230:
231: -------------------------------------------------------------------------
232: -- Initialize common variables
2878: SELECT meaa.asset_activity_id, pm_schedule_id, action_type, fw.wip_entity_id, fw.wo_status,ewsv.system_status,fw.cycle_id,fw.seq_id,maintenance_object_type, maintenance_object_id,
2879: meaa.inventory_item_id, default_eam_class wip_acct_class,meaa.eam_item_type,
2880: scheduled_start_date, scheduled_completion_date, meaa.organization_id
2881: from eam_forecasted_work_orders fw, mtl_eam_asset_activities_v meaa,
2882: wip_eam_parameters wep, mtl_system_items msi,eam_wo_statuses_v ewsv
2883: where group_id = l_group_id
2884: and wep.organization_id = meaa.organization_id
2885: and fw.activity_association_id = meaa.activity_association_id
2886: and meaa.inventory_item_id = msi.inventory_item_id