DBA Data[Home] [Help]

APPS.PJM_UNIT_EFF dependencies on WIP_ENTITIES

Line 385: , wip_entities e

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
389: AND fs.wip_entity_id (+) = e.wip_entity_id

Line 421: , wip_entities e

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
425: AND fs.wip_entity_id (+) = e.wip_entity_id