DBA Data[Home] [Help]

APPS.RCV_ASN_TRX_INSERT dependencies on RCV_SHIPMENT_LINES

Line 512: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface

508:
509: delete from rcv_transactions_interface
510: where header_interface_id = v_header_record.header_record.header_interface_id;
511:
512: -- Insert lines from rcv_shipment_lines into rcv_transactions_interface
513:
514: -- Make sure we don't inset cancelled lines and lines that are waiting to
515: -- be cancelled in rti
516: -- The transaction processor will then cancel the lines

Line 587: FROM rcv_shipment_lines rsl

583: rsl.po_line_location_id,
584: rsl.shipment_header_id,
585: rsl.shipment_line_id,
586: rsl.destination_type_code, V_header_record.header_record.processing_request_id
587: FROM rcv_shipment_lines rsl
588: WHERE rsl.shipment_header_id = V_header_record.header_record.receipt_header_id and
589: rsl.shipment_line_status_code <> 'CANCELLED' and
590: not exists (select 'x' from rcv_transactions_interface rti
591: where