APPS.EAM_PMDEF_PUB dependencies on WIP_DISCRETE_JOBS

Line 2420: from eam_job_completion_txns ejct, wip_discrete_jobs wdj

2416: max(ejct.actual_end_date) into
2417: l_last_service_start_date,
2418: l_last_service_end_date
2419:
2420: from eam_job_completion_txns ejct, wip_discrete_jobs wdj
2421: where wdj.wip_entity_id = ejct.wip_entity_id
2422: and wdj.maintenance_object_id=l_maintenance_object_id
2423: and wdj.primary_item_id=l_asset_activity_id
2424: and ejct.transaction_type=1;

Line 2451: wip_discrete_jobs wdj

2447: begin
2448:
2449: select transaction_id into l_transaction_id from
2450: ( select max(actual_end_date),transaction_id from eam_job_completion_txns ejct,
2451: wip_discrete_jobs wdj
2452: where ejct.transaction_type=1 and
2453: wdj.wip_entity_id = ejct.wip_entity_id and
2454: wdj.maintenance_object_id = l_maintenance_object_id and
2455: wdj.primary_item_id = l_asset_activity_id group by ejct.transaction_id order by ejct.transaction_id desc) where rownum = 1;

Line 2470: FROM eam_job_completion_txns ejct, wip_discrete_jobs wdj WHERE wdj.primary_item_id=l_asset_activity_id

2466:
2467: SELECT wdj.scheduled_start_date,
2468: wdj.scheduled_completion_date,wdj.wip_entity_id
2469: into l_last_scheduled_start_date,l_last_scheduled_end_date,l_wip_entity_id
2470: FROM eam_job_completion_txns ejct, wip_discrete_jobs wdj WHERE wdj.primary_item_id=l_asset_activity_id
2471: and
2472: wdj.maintenance_object_id=l_maintenance_object_id and
2473: ejct.transaction_id=l_transaction_id and ejct.transaction_type=1 and
2474: ejct.wip_entity_id=wdj.wip_entity_id;