DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on WIP_DISCRETE_JOBS

Line 506: , wip_discrete_jobs wipdj

502: , TO_CHAR(wipdj.scheduled_completion_date, g_date_format_mask) job_scheduled_completion_date
503: , wipdj.bom_revision job_bom_revision
504: , wipdj.routing_revision job_routing_revision
505: FROM wip_entities wipent
506: , wip_discrete_jobs wipdj
507: , mfg_lookups mfglkp
508: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
509: AND wipdj.organization_id = wipent.organization_id
510: AND mfglkp.lookup_code(+) = wipent.entity_type

Line 1752: , wip_discrete_jobs wipdj

1748: , l_scheduled_completion_date
1749: , l_bom_revision
1750: , l_routing_revision
1751: FROM wip_entities wipent
1752: , wip_discrete_jobs wipdj
1753: , mfg_lookups mfglkp
1754: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
1755: AND wipdj.organization_id = wipent.organization_id
1756: AND mfglkp.lookup_code(+) = wipent.entity_type

Line 3506: , wip_discrete_jobs wipdj

3502: , l_scheduled_completion_date
3503: , l_bom_revision
3504: , l_routing_revision
3505: FROM wip_entities wipent
3506: , wip_discrete_jobs wipdj
3507: , mfg_lookups mfglkp
3508: WHERE wipdj.wip_entity_id = wipent.wip_entity_id
3509: AND wipdj.organization_id = wipent.organization_id
3510: AND mfglkp.lookup_code(+) = wipent.entity_type