APPS.EAM_PMDEF_PUB dependencies on WIP_DISCRETE_JOBS

Line 2507: from eam_job_completion_txns ejct, wip_discrete_jobs wdj

2503: max(ejct.actual_end_date) into
2504: l_last_service_start_date,
2505: l_last_service_end_date
2506:
2507: from eam_job_completion_txns ejct, wip_discrete_jobs wdj
2508: where wdj.wip_entity_id = ejct.wip_entity_id
2509: and wdj.maintenance_object_id=l_maintenance_object_id
2510: and wdj.primary_item_id=l_asset_activity_id
2511: and ejct.transaction_type=1;

Line 2538: wip_discrete_jobs wdj

2534: begin
2535:
2536: select transaction_id into l_transaction_id from
2537: ( select max(actual_end_date),transaction_id from eam_job_completion_txns ejct,
2538: wip_discrete_jobs wdj
2539: where ejct.transaction_type=1 and
2540: wdj.wip_entity_id = ejct.wip_entity_id and
2541: wdj.maintenance_object_id = l_maintenance_object_id and
2542: wdj.primary_item_id = l_asset_activity_id group by ejct.transaction_id order by ejct.transaction_id desc) where rownum = 1;

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

2553:
2554: SELECT wdj.scheduled_start_date,
2555: wdj.scheduled_completion_date,wdj.wip_entity_id
2556: into l_last_scheduled_start_date,l_last_scheduled_end_date,l_wip_entity_id
2557: FROM eam_job_completion_txns ejct, wip_discrete_jobs wdj WHERE wdj.primary_item_id=l_asset_activity_id
2558: and
2559: wdj.maintenance_object_id=l_maintenance_object_id and
2560: ejct.transaction_id=l_transaction_id and ejct.transaction_type=1 and
2561: ejct.wip_entity_id=wdj.wip_entity_id;