DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on RCV_TRANSACTIONS

Line 3402: , rcv_transactions rt

3398: ,l_receipt_num
3399: ,l_receipt_date
3400: FROM rcv_shipment_lines rcvl
3401: ,rcv_shipment_headers rcvh
3402: , rcv_transactions rt
3403: WHERE rcvl.shipment_header_id = rcvh.shipment_header_id
3404: AND rt.shipment_header_id = rcvh.shipment_header_id
3405: AND rt.transaction_type IN ('RECEIVE', 'MATCH')
3406: AND rcvl.shipment_line_id = l_shipment_line_id_tbl(i)

Line 4096: rcv_transactions rcvt

4092: BEGIN
4093: SELECT 'Y'
4094: INTO l_match_exists
4095: FROM ap_invoice_lines_all inv,
4096: rcv_transactions rcvt
4097: WHERE inv.rcv_transaction_id = rcvt.transaction_id
4098: AND inv.match_type = 'ITEM_TO_RECEIPT'
4099: AND rcvt.shipment_line_id = p_shipment_line_id;
4100: EXCEPTION

Line 4161: rcv_transactions rcvt

4157: BEGIN
4158: SELECT inv.invoice_id
4159: INTO l_invoice_id
4160: FROM ap_invoice_lines_all inv,
4161: rcv_transactions rcvt
4162: WHERE inv.rcv_transaction_id = rcvt.transaction_id
4163: AND inv.match_type = 'ITEM_TO_RECEIPT'
4164: AND rcvt.shipment_line_id = p_doc_id;
4165: EXCEPTION