APPS.POR_RCV_TRANSACTION_SV dependencies on RCV_SHIPMENT_LINES

Line 69: RCV_SHIPMENT_LINES RL,

65: X_ITEM_ID,
66: X_PARENT_TYPE,
67: X_TXN_ORG_ID
68: FROM RCV_TRANSACTIONS RT,
69: RCV_SHIPMENT_LINES RL,
70: PO_HEADERS_ALL PH,
71: OE_ORDER_HEADERS_ALL OH
72: WHERE RT.TRANSACTION_ID = P_PARENT_TRANSACTION_ID
73: AND RT.SHIPMENT_LINE_ID = RL.SHIPMENT_LINE_ID

Line 747: rcv_shipment_lines rl,

743: x_create_debit_memo_flag,
744: rt.job_id,
745: pol.matching_basis
746: from rcv_transactions rt,
747: rcv_shipment_lines rl,
748: rcv_shipment_headers rh,
749: mtl_system_items msi,
750: po_Lines_all pol
751: where transaction_id = p_parent_transaction_id

Line 803: rcv_shipment_lines rsl

799: SELECT
800: rsh.shipment_num, rsh.shipment_header_id
801: FROM
802: rcv_shipment_headers rsh,
803: rcv_shipment_lines rsl
804: WHERE
805: rsh.shipment_header_id = rsl.shipment_header_id and
806: rsl.requisition_line_id = c_req_line_id;
807:

Line 813: rcv_shipment_lines rsl

809: SELECT
810: rsh.shipment_num, rsh.shipment_header_id
811: FROM
812: rcv_shipment_headers rsh,
813: rcv_shipment_lines rsl
814: WHERE
815: rsh.shipment_header_id = rsl.shipment_header_id and
816: rsl.po_line_location_id = c_line_location_id and
817: rsh.asn_type is not null;