eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_INVOICE_MATCHING_SV dependencies on RCV_TRANSACTIONS

Line 81: rcv_transactions

77: shipment_line_id,
78: po_line_location_id,
79: parent_transaction_id
80: FROM
81: rcv_transactions
82: START WITH transaction_id = c_transaction_id
83: CONNECT BY parent_transaction_id = PRIOR transaction_id;
84:
85: BEGIN

Line 164: rcv_transactions

160: transaction_type
161: INTO
162: v_parent_type
163: FROM
164: rcv_transactions
165: WHERE
166: transaction_id = v_parent_id;
167:
168: if v_parent_type = 'ACCEPT' THEN

Line 198: rcv_transactions

194: transaction_type
195: INTO
196: v_parent_type
197: FROM
198: rcv_transactions
199: WHERE
200: transaction_id = v_parent_id;
201:
202: if v_parent_type <> 'ACCEPT' THEN

Line 220: rcv_transactions

216: transaction_type
217: INTO
218: v_parent_type
219: FROM
220: rcv_transactions
221: WHERE
222: transaction_id = v_parent_id;
223:
224: if v_parent_type <> 'REJECT' then

Line 244: rcv_transactions

240: transaction_type,parent_transaction_id
241: INTO
242: v_parent_type,grand_parent_id
243: FROM
244: rcv_transactions
245: WHERE
246: transaction_id = v_parent_id;
247:
248: /*Bug 2288641 Handling the No data found exception becuase when correction is

Line 260: rcv_transactions

256: transaction_type
257: INTO
258: grand_parent_type
259: FROM
260: rcv_transactions
261: WHERE
262: transaction_id = grand_parent_id;
263: EXCEPTION
264:

Line 364: rcv_transactions rt

360: cancelled_po_qty,
361: billed_txn_qty
362: FROM
363: po_line_locations ps,
364: rcv_transactions rt
365: WHERE
366: rt.transaction_id = top_transaction_id and
367: rt.po_line_location_id = ps.line_location_id;
368: ELSE

Line 478: rcv_transactions

474: primary_quantity,
475: transaction_type,
476: parent_transaction_id
477: FROM
478: rcv_transactions
479: START WITH transaction_id = c_transaction_id
480: CONNECT BY parent_transaction_id = PRIOR transaction_id;
481:
482: /* This cursor query up the all the deliver transactions */

Line 488: rcv_transactions

484: CURSOR c_deliver_txn (c_transaction_id NUMBER, c_distribution_id NUMBER) IS
485: SELECT
486: transaction_id
487: FROM
488: rcv_transactions
489: WHERE
490: transaction_type = 'DELIVER' AND
491: po_distribution_id = c_distribution_id
492: START WITH transaction_id = c_transaction_id

Line 520: rcv_transactions rt

516: X_po_uom,
517: X_txn_uom
518: FROM
519: rcv_shipment_lines sl,
520: rcv_transactions rt
521: WHERE
522: rt.transaction_id = rcv_transaction_id AND
523: rt.shipment_line_id = sl.shipment_line_id;
524:

Line 568: rcv_transactions

564: transaction_type
565: INTO
566: v_parent_type
567: FROM
568: rcv_transactions
569: WHERE
570: transaction_id = v_parent_id;
571:
572: IF v_parent_type = 'DELIVER' THEN

Line 642: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed

638: x_return_status OUT NOCOPY VARCHAR2,
639: x_msg_count OUT NOCOPY NUMBER,
640: x_msg_data OUT NOCOPY VARCHAR2,
641: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
642: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
643: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
644: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
645: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
646: ) IS

Line 643: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction

639: x_msg_count OUT NOCOPY NUMBER,
640: x_msg_data OUT NOCOPY VARCHAR2,
641: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
642: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
643: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
644: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
645: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
646: ) IS
647: l_api_name CONSTANT VARCHAR2(30) := 'Get_ReceiveAmount';

Line 644: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction

640: x_msg_data OUT NOCOPY VARCHAR2,
641: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
642: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
643: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
644: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
645: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
646: ) IS
647: l_api_name CONSTANT VARCHAR2(30) := 'Get_ReceiveAmount';
648: l_api_version CONSTANT NUMBER := 1.0;

Line 645: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction

641: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
642: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
643: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
644: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
645: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
646: ) IS
647: l_api_name CONSTANT VARCHAR2(30) := 'Get_ReceiveAmount';
648: l_api_version CONSTANT NUMBER := 1.0;
649:

Line 665: rcv_transactions

661: po_line_location_id,
662: parent_transaction_id,
663: PRIOR transaction_type parent_transaction_type
664: FROM
665: rcv_transactions
666: START WITH transaction_id = c_transaction_id
667: CONNECT BY parent_transaction_id = PRIOR transaction_id;
668:
669: BEGIN

Line 733: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the child DELIVER transactions

729: x_msg_count OUT NOCOPY NUMBER,
730: x_msg_data OUT NOCOPY VARCHAR2,
731: p_receive_transaction_id IN NUMBER, -- Transaction id of the root RECEIVE transaction
732: p_po_distribution_id IN NUMBER,
733: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the child DELIVER transactions
734: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the child CORRECT transactions
735: ) IS
736: l_api_name CONSTANT VARCHAR2(30) := 'Get_DeliverAmount';
737: l_api_version CONSTANT NUMBER := 1.0;

Line 734: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the child CORRECT transactions

730: x_msg_data OUT NOCOPY VARCHAR2,
731: p_receive_transaction_id IN NUMBER, -- Transaction id of the root RECEIVE transaction
732: p_po_distribution_id IN NUMBER,
733: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the child DELIVER transactions
734: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the child CORRECT transactions
735: ) IS
736: l_api_name CONSTANT VARCHAR2(30) := 'Get_DeliverAmount';
737: l_api_version CONSTANT NUMBER := 1.0;
738:

Line 752: rcv_transactions

748: transaction_type,
749: parent_transaction_id,
750: PRIOR transaction_type parent_transaction_type
751: FROM
752: rcv_transactions
753: START WITH transaction_id = c_transaction_id
754: CONNECT BY parent_transaction_id = PRIOR transaction_id;
755:
756: /* This cursor query up the all the deliver transactions */

Line 761: rcv_transactions

757: CURSOR c_deliver_txn (c_transaction_id NUMBER, c_distribution_id NUMBER) IS
758: SELECT
759: transaction_id
760: FROM
761: rcv_transactions
762: WHERE
763: transaction_type = 'DELIVER' AND
764: po_distribution_id = c_distribution_id
765: START WITH transaction_id = c_transaction_id