APPS.PO_DELREC_PVT dependencies on RCV_TRANSACTIONS

Line 873: rcv_transactions rt,

869: FROM
870: po_headers_all poh,
871: po_lines_all pol,
872: po_line_locations_all pll,
873: rcv_transactions rt,
874: mtl_system_items msi,
875: fnd_lookup_values fl,
876: po_releases_all por,
877: mtl_units_of_measure muom,

Line 892: FROM rcv_transactions

888: SELECT shipment_header_id,
889: shipment_line_id,
890: sum(quantity) squant,
891: max(transaction_id) maxtrans
892: FROM rcv_transactions
893: WHERE shipment_header_id = p_header_id
894: AND transaction_type IN ('RECEIVE', 'MATCH')
895: AND p_action IN ('RECEIPT', 'MATCH')
896: GROUP BY shipment_line_id,

Line 933: FROM rcv_transactions

929: )
930: OR rt.transaction_id IN
931: (
932: SELECT max(transaction_id)
933: FROM rcv_transactions
934: WHERE shipment_header_id = p_header_id
935: AND transaction_type = 'RECEIVE'
936: AND p_action = 'RECEIPT_HEADER_UPD'
937: )

Line 1168: rcv_transactions rt,

1164: FROM
1165: po_headers_all poh,
1166: po_lines_all pol,
1167: po_line_locations_all pll,
1168: rcv_transactions rt,
1169: mtl_system_items msi,
1170: fnd_lookup_values fl,
1171: po_releases_all por,
1172: mtl_units_of_measure muom,