DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on WIP_DISCRETE_JOBS

Line 725: , wip_discrete_jobs wdj -- Added for Bug#4516067

721: , rcv_routing_headers rrh
722: -- Bug 4516067, to improve performance, query the base table directly
723: --, wip_osp_jobs_val_v wojv
724: , wip_entities we -- Added for Bug#4516067
725: , wip_discrete_jobs wdj -- Added for Bug#4516067
726: , wms_license_plate_numbers wlpn -- Bug 3836623
727: , (SELECT cost_group_id, rcv_transaction_id
728: FROM mtl_material_transactions mmt1
729: WHERE mmt1.rcv_transaction_id = p_transaction_id

Line 923: , wip_discrete_jobs wdj

919: , rcv_routing_headers rrh
920: -- Bug 4516067, to improve performance, query the base table directly
921: --, wip_osp_jobs_val_v wojv
922: , wip_entities we
923: , wip_discrete_jobs wdj
924: , wms_license_plate_numbers wlpn -- Bug 3836623
925: , (SELECT cost_group_id, rcv_transaction_id
926: FROM mtl_material_transactions mmt1
927: WHERE mmt1.rcv_transaction_id = p_transaction_id

Line 1106: , wip_discrete_jobs wdj

1102: , rcv_routing_headers rrh
1103: -- Bug 4516067, to improve performance, query the base table directly
1104: --, wip_osp_jobs_val_v wojv
1105: , wip_entities we
1106: , wip_discrete_jobs wdj
1107: , wms_license_plate_numbers wlpn -- Bug 3836623
1108: WHERE mtln.product_transaction_id(+) = rt.transaction_id
1109: AND mtln.product_code(+) = 'RCV'
1110: AND pol.po_line_id(+) = rt.po_line_id