[Home] [Help]
1709: , po_line_locations poll
1710: , po_lines pol
1711: , po_releases por
1712: , mtl_system_items msi
1713: , mtl_units_of_measure mum
1714: WHERE poll.line_location_id = v_po_line_location_id
1715: AND poh.po_header_id = poll.po_header_id
1716: AND pol.po_line_id = poll.po_line_id
1717: AND poll.po_release_id = por.po_release_id(+)
2649: , po_requisition_headers porh
2650: , po_requisition_lines porl
2651: , mtl_system_items msi
2652: , mtl_system_items msi1
2653: , mtl_units_of_measure mum
2654: WHERE rsh.receipt_source_code <> 'VENDOR'
2655: AND rsl.requisition_line_id = porl.requisition_line_id(+)
2656: AND porl.requisition_header_id = porh.requisition_header_id(+)
2657: AND rsh.shipment_header_id = rsl.shipment_header_id
3325: , NULL secondary_quantity --OPM Convergence
3326: FROM oe_order_lines_all oel
3327: , oe_order_headers_all oeh
3328: , mtl_system_items msi
3329: , mtl_units_of_measure mum
3330: WHERE oel.line_category_code = 'RETURN'
3331: AND oel.header_id = oeh.header_id
3332: AND oel.inventory_item_id = msi.inventory_item_id
3333: AND oel.ship_from_org_id = msi.organization_id
3921: , po_line_locations poll
3922: , po_lines pol
3923: , po_releases por
3924: , mtl_system_items msi
3925: , mtl_units_of_measure mum
3926: WHERE NVL(poll.approved_flag, 'N') = 'Y'
3927: AND NVL(poll.cancel_flag, 'N') = 'N'
3928: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
3929: AND poll.shipment_type IN('STANDARD', 'BLANKET', 'SCHEDULED')
4092: , po_requisition_headers porh
4093: , po_requisition_lines porl
4094: , mtl_system_items msi
4095: , mtl_system_items msi1
4096: , mtl_units_of_measure mum
4097: WHERE rsh.receipt_source_code <> 'VENDOR'
4098: AND rsl.requisition_line_id = porl.requisition_line_id(+)
4099: AND porl.requisition_header_id = porh.requisition_header_id(+)
4100: AND rsh.shipment_header_id = rsl.shipment_header_id