[Home] [Help]
1758: , po_line_locations poll
1759: , po_lines pol
1760: , po_releases por
1761: , mtl_system_items msi
1762: , mtl_units_of_measure mum
1763: WHERE poll.line_location_id = v_po_line_location_id
1764: AND poh.po_header_id = poll.po_header_id
1765: AND pol.po_line_id = poll.po_line_id
1766: AND poll.po_release_id = por.po_release_id(+)
2705: , po_requisition_headers porh
2706: , po_requisition_lines porl
2707: , mtl_system_items msi
2708: , mtl_system_items msi1
2709: , mtl_units_of_measure mum
2710: WHERE rsh.receipt_source_code <> 'VENDOR'
2711: AND rsl.requisition_line_id = porl.requisition_line_id(+)
2712: AND porl.requisition_header_id = porh.requisition_header_id(+)
2713: AND rsh.shipment_header_id = rsl.shipment_header_id
3488: , NULL secondary_quantity --OPM Convergence
3489: FROM oe_order_lines_all oel
3490: , oe_order_headers_all oeh
3491: , mtl_system_items msi
3492: , mtl_units_of_measure mum
3493: WHERE oel.line_category_code = 'RETURN'
3494: AND oel.header_id = oeh.header_id
3495: AND oel.inventory_item_id = msi.inventory_item_id
3496: AND oel.ship_from_org_id = msi.organization_id
4102: , po_line_locations poll
4103: , po_lines pol
4104: , po_releases por
4105: , mtl_system_items msi
4106: , mtl_units_of_measure mum
4107: WHERE NVL(poll.approved_flag, 'N') = 'Y'
4108: AND NVL(poll.cancel_flag, 'N') = 'N'
4109: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
4110: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
4273: , po_requisition_headers porh
4274: , po_requisition_lines porl
4275: , mtl_system_items msi
4276: , mtl_system_items msi1
4277: , mtl_units_of_measure mum
4278: WHERE rsh.receipt_source_code <> 'VENDOR'
4279: AND rsl.requisition_line_id = porl.requisition_line_id(+)
4280: AND porl.requisition_header_id = porh.requisition_header_id(+)
4281: AND rsh.shipment_header_id = rsl.shipment_header_id