13: (transaction_type ='SHIP' and auto_transact_code in ('RECEIVE','DELIVER'))
14: )
15: and source_document_code = 'PO'
16: and exists ( select 'lcm shipment'
17: from po_line_locations_all pll
18: where pll.line_location_id = rti.po_line_location_id
19: and pll.lcm_flag = 'Y'
20: )
21: and shipment_header_id IS NOT NULL
32: (transaction_type ='SHIP' and auto_transact_code in ('RECEIVE','DELIVER'))
33: )
34: and source_document_code = 'PO'
35: and exists ( select 'lcm shipment'
36: from po_line_locations_all pll
37: where pll.line_location_id = rti.po_line_location_id
38: and pll.lcm_flag = 'Y'
39: )
40: and shipment_header_id IS NULL