DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on WIP_DISCRETE_JOBS

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

708: , rcv_routing_headers rrh
709: -- Bug 4516067, to improve performance, query the base table directly
710: --, wip_osp_jobs_val_v wojv
711: , wip_entities we -- Added for Bug#4516067
712: , wip_discrete_jobs wdj -- Added for Bug#4516067
713: , wms_license_plate_numbers wlpn -- Bug 3836623
714: , (SELECT cost_group_id, rcv_transaction_id
715: FROM mtl_material_transactions mmt1
716: WHERE mmt1.rcv_transaction_id = p_transaction_id

Line 898: , wip_discrete_jobs wdj

894: , rcv_routing_headers rrh
895: -- Bug 4516067, to improve performance, query the base table directly
896: --, wip_osp_jobs_val_v wojv
897: , wip_entities we
898: , wip_discrete_jobs wdj
899: , wms_license_plate_numbers wlpn -- Bug 3836623
900: , (SELECT cost_group_id, rcv_transaction_id
901: FROM mtl_material_transactions mmt1
902: WHERE mmt1.rcv_transaction_id = p_transaction_id

Line 1069: , wip_discrete_jobs wdj

1065: , rcv_routing_headers rrh
1066: -- Bug 4516067, to improve performance, query the base table directly
1067: --, wip_osp_jobs_val_v wojv
1068: , wip_entities we
1069: , wip_discrete_jobs wdj
1070: , wms_license_plate_numbers wlpn -- Bug 3836623
1071: WHERE mtln.product_transaction_id(+) = rt.transaction_id
1072: AND mtln.product_code(+) = 'RCV'
1073: AND pol.po_line_id(+) = rt.po_line_id