DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on MFG_LOOKUPS

Line 507: , mfg_lookups mfglkp

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
511: AND mfglkp.lookup_type(+) = 'WIP_ENTITY'

Line 1753: , mfg_lookups mfglkp

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
1757: AND mfglkp.lookup_type(+) = 'WIP_ENTITY'

Line 3507: , mfg_lookups mfglkp

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
3511: AND mfglkp.lookup_type(+) = 'WIP_ENTITY'