DBA Data[Home] [Help]

APPS.PJM_UNIT_EFF dependencies on WIP_DISCRETE_JOBS

Line 384: , wip_discrete_jobs dj

380: SELECT DECODE(e.entity_type, 1, dj.end_item_unit_number,
381: 4, fs.end_item_unit_number)
382: INTO G_WIP_Unit_Num
383: FROM wip_flow_schedules fs
384: , wip_discrete_jobs dj
385: , wip_entities e
386: WHERE e.wip_entity_id = X_wip_entity_id
387: AND e.organization_id = X_organization_id
388: AND fs.organization_id (+) = e.organization_id

Line 420: , wip_discrete_jobs dj

416: SELECT DECODE(e.entity_type, 1, dj.end_item_unit_number,
417: 4, fs.end_item_unit_number)
418: INTO G_WIP_Unit_Num
419: FROM wip_flow_schedules fs
420: , wip_discrete_jobs dj
421: , wip_entities e
422: WHERE e.wip_entity_id = X_wip_entity_id
423: AND e.organization_id = X_organization_id
424: AND fs.organization_id (+) = e.organization_id