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 84: rcv_transactions

80: po_line_location_id,
81: po_distribution_id, --Bug 10074319
82: parent_transaction_id
83: FROM
84: rcv_transactions
85: START WITH transaction_id = c_transaction_id
86: CONNECT BY parent_transaction_id = PRIOR transaction_id;
87:
88: BEGIN

Line 169: rcv_transactions

165: transaction_type
166: INTO
167: v_parent_type
168: FROM
169: rcv_transactions
170: WHERE
171: transaction_id = v_parent_id;
172:
173: if v_parent_type = 'ACCEPT' THEN

Line 203: rcv_transactions

199: transaction_type
200: INTO
201: v_parent_type
202: FROM
203: rcv_transactions
204: WHERE
205: transaction_id = v_parent_id;
206:
207: if v_parent_type <> 'ACCEPT' THEN

Line 225: rcv_transactions

221: transaction_type
222: INTO
223: v_parent_type
224: FROM
225: rcv_transactions
226: WHERE
227: transaction_id = v_parent_id;
228:
229: if v_parent_type <> 'REJECT' then

Line 249: rcv_transactions

245: transaction_type,parent_transaction_id
246: INTO
247: v_parent_type,grand_parent_id
248: FROM
249: rcv_transactions
250: WHERE
251: transaction_id = v_parent_id;
252:
253: /*Bug 2288641 Handling the No data found exception becuase when correction is

Line 265: rcv_transactions

261: transaction_type
262: INTO
263: grand_parent_type
264: FROM
265: rcv_transactions
266: WHERE
267: transaction_id = grand_parent_id;
268: EXCEPTION
269:

Line 369: rcv_transactions rt

365: cancelled_po_qty,
366: billed_txn_qty
367: FROM
368: po_distributions pod,
369: rcv_transactions rt
370: WHERE
371: rt.transaction_id = top_transaction_id and
372: rt.po_distribution_id = pod.po_distribution_id;
373: ELSIF X_line_location_id IS NOT NULL THEN

Line 384: rcv_transactions rt

380: cancelled_po_qty,
381: billed_txn_qty
382: FROM
383: po_line_locations ps,
384: rcv_transactions rt
385: WHERE
386: rt.transaction_id = top_transaction_id and
387: rt.po_line_location_id = ps.line_location_id;
388: ELSE

Line 499: rcv_transactions

495: primary_quantity,
496: transaction_type,
497: parent_transaction_id
498: FROM
499: rcv_transactions
500: START WITH transaction_id = c_transaction_id
501: CONNECT BY parent_transaction_id = PRIOR transaction_id;
502:
503: /* This cursor query up the all the deliver transactions */

Line 509: rcv_transactions

505: CURSOR c_deliver_txn (c_transaction_id NUMBER, c_distribution_id NUMBER) IS
506: SELECT
507: transaction_id
508: FROM
509: rcv_transactions
510: WHERE
511: transaction_type = 'DELIVER' AND
512: po_distribution_id = c_distribution_id
513: START WITH transaction_id = c_transaction_id

Line 541: rcv_transactions rt

537: X_po_uom,
538: X_txn_uom
539: FROM
540: rcv_shipment_lines sl,
541: rcv_transactions rt
542: WHERE
543: rt.transaction_id = rcv_transaction_id AND
544: rt.shipment_line_id = sl.shipment_line_id;
545:

Line 589: rcv_transactions

585: transaction_type
586: INTO
587: v_parent_type
588: FROM
589: rcv_transactions
590: WHERE
591: transaction_id = v_parent_id;
592:
593: IF v_parent_type = 'DELIVER' THEN

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

659: x_return_status OUT NOCOPY VARCHAR2,
660: x_msg_count OUT NOCOPY NUMBER,
661: x_msg_data OUT NOCOPY VARCHAR2,
662: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
663: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
664: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
665: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
666: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
667: ) IS

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

660: x_msg_count OUT NOCOPY NUMBER,
661: x_msg_data OUT NOCOPY VARCHAR2,
662: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
663: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
664: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
665: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
666: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
667: ) IS
668: l_api_name CONSTANT VARCHAR2(30) := 'Get_ReceiveAmount';

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

661: x_msg_data OUT NOCOPY VARCHAR2,
662: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
663: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
664: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
665: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
666: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
667: ) IS
668: l_api_name CONSTANT VARCHAR2(30) := 'Get_ReceiveAmount';
669: l_api_version CONSTANT NUMBER := 1.0;

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

662: p_receive_transaction_id IN NUMBER, -- RECEIVE Transaction id
663: x_billed_amt OUT NOCOPY NUMBER, -- rcv_transactions.amount_billed
664: x_received_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding RECEIVE transaction
665: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the corresponding DELIVER transaction
666: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the corresponding CORRECT transaction
667: ) IS
668: l_api_name CONSTANT VARCHAR2(30) := 'Get_ReceiveAmount';
669: l_api_version CONSTANT NUMBER := 1.0;
670:

Line 686: rcv_transactions

682: po_line_location_id,
683: parent_transaction_id,
684: PRIOR transaction_type parent_transaction_type
685: FROM
686: rcv_transactions
687: START WITH transaction_id = c_transaction_id
688: CONNECT BY parent_transaction_id = PRIOR transaction_id;
689:
690: BEGIN

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

750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: p_receive_transaction_id IN NUMBER, -- Transaction id of the root RECEIVE transaction
753: p_po_distribution_id IN NUMBER,
754: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the child DELIVER transactions
755: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the child CORRECT transactions
756: ) IS
757: l_api_name CONSTANT VARCHAR2(30) := 'Get_DeliverAmount';
758: l_api_version CONSTANT NUMBER := 1.0;

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

751: x_msg_data OUT NOCOPY VARCHAR2,
752: p_receive_transaction_id IN NUMBER, -- Transaction id of the root RECEIVE transaction
753: p_po_distribution_id IN NUMBER,
754: x_delivered_amt OUT NOCOPY NUMBER, -- amount from rcv transactions table for the child DELIVER transactions
755: x_corrected_amt OUT NOCOPY NUMBER -- amount from rcv transactions table for the child CORRECT transactions
756: ) IS
757: l_api_name CONSTANT VARCHAR2(30) := 'Get_DeliverAmount';
758: l_api_version CONSTANT NUMBER := 1.0;
759:

Line 773: rcv_transactions

769: transaction_type,
770: parent_transaction_id,
771: PRIOR transaction_type parent_transaction_type
772: FROM
773: rcv_transactions
774: START WITH transaction_id = c_transaction_id
775: CONNECT BY parent_transaction_id = PRIOR transaction_id;
776:
777: /* This cursor query up the all the deliver transactions */

Line 782: rcv_transactions

778: CURSOR c_deliver_txn (c_transaction_id NUMBER, c_distribution_id NUMBER) IS
779: SELECT
780: transaction_id
781: FROM
782: rcv_transactions
783: WHERE
784: transaction_type = 'DELIVER' AND
785: po_distribution_id = c_distribution_id
786: START WITH transaction_id = c_transaction_id