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.PA_PO_INTEGRATION_UTILS dependencies on RCV_TRANSACTIONS

Line 29: from rcv_transactions rcv_txn,

25:
26: BEGIN
27: select sum(nvl(entered_cr,0) - nvl(entered_dr,0))
28: into l_sum_amount_interfaced
29: from rcv_transactions rcv_txn,
30: rcv_receiving_sub_ledger rcv_sub
31: where rcv_txn.po_distribution_id = l_po_distribution_id
32: and rcv_sub.rcv_transaction_id = rcv_txn.transaction_id
33: and rcv_sub.pa_addition_flag in ('Y','I')

Line 54: (SELECT 1 FROM rcv_transactions rcv_txn,

50: select 1
51: into l_uninterfaced_to_pa
52: FROM dual
53: WHERE EXISTS
54: (SELECT 1 FROM rcv_transactions rcv_txn,
55: rcv_receiving_sub_ledger rcv_sub
56: ,po_distributions_all podist/*Bug 3905697*/
57: where rcv_txn.po_distribution_id = l_po_distribution_id
58: and podist.po_distribution_id=rcv_txn.po_distribution_id/*Bug 3905697*/

Line 92: (SELECT 1 FROM rcv_transactions rcv_txn,

88: select 1
89: into l_uninterfaced_to_pa
90: FROM dual
91: WHERE EXISTS
92: (SELECT 1 FROM rcv_transactions rcv_txn,
93: rcv_receiving_sub_ledger rcv_sub
94: ,po_distributions_all podist/*Bug 3905697*/
95: where rcv_txn.po_distribution_id = l_po_distribution_id
96: and podist.po_distribution_id=rcv_txn.po_distribution_id/*Bug 3905697*/

Line 204: FROM rcv_transactions rcv_txn

200: CURSOR net_zero_po_proj (p_transaction_id IN number) IS /* Modified the cursor query for Bug 5585218 */
201: SELECT /*+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_txn.transaction_id /*4338075*/
202: ,rcv_txn.po_distribution_id
203: ,rcvsub.accounting_event_id -- pricing changes
204: FROM rcv_transactions rcv_txn
205: ,po_distributions podist
206: ,rcv_receiving_sub_ledger rcvsub
207: WHERE rcv_txn.transaction_id = rcvsub.rcv_transaction_id
208: AND rcv_txn.parent_transaction_id = (SELECT parent_transaction_id

Line 209: FROM rcv_transactions rcv_txn3

205: ,po_distributions podist
206: ,rcv_receiving_sub_ledger rcvsub
207: WHERE rcv_txn.transaction_id = rcvsub.rcv_transaction_id
208: AND rcv_txn.parent_transaction_id = (SELECT parent_transaction_id
209: FROM rcv_transactions rcv_txn3
210: WHERE rcv_txn3.transaction_id = p_transaction_id)
211: and rcv_txn.po_distribution_id = podist.po_distribution_id
212: and podist.code_combination_id = rcvsub.code_combination_id
213: and rcvsub.actual_flag = 'A'

Line 221: and 0 = (SELECT /+ INDEX(RCV_TXN2 RCV_TRANSACTIONS_N1) /sum(nvl(rcvsub2.entered_dr,0)-nvl(rcvsub2.entered_cr,0))/4338075/

217: and ((rcv_txn.destination_type_code = 'EXPENSE' ) OR
218: (rcv_txn.destination_type_code = 'RECEIVING' AND
219: rcv_txn.transaction_type in ('RETURN TO VENDOR','RETURN TO RECEIVING')
220: ))
221: and 0 = (SELECT /*+ INDEX(RCV_TXN2 RCV_TRANSACTIONS_N1) */sum(nvl(rcvsub2.entered_dr,0)-nvl(rcvsub2.entered_cr,0))/*4338075*/
222: FROM rcv_transactions rcv_txn2
223: ,rcv_receiving_sub_ledger rcvsub2
224: ,po_distributions podist2
225: WHERE rcv_txn2.transaction_id = rcvsub2.rcv_transaction_id

Line 222: FROM rcv_transactions rcv_txn2

218: (rcv_txn.destination_type_code = 'RECEIVING' AND
219: rcv_txn.transaction_type in ('RETURN TO VENDOR','RETURN TO RECEIVING')
220: ))
221: and 0 = (SELECT /*+ INDEX(RCV_TXN2 RCV_TRANSACTIONS_N1) */sum(nvl(rcvsub2.entered_dr,0)-nvl(rcvsub2.entered_cr,0))/*4338075*/
222: FROM rcv_transactions rcv_txn2
223: ,rcv_receiving_sub_ledger rcvsub2
224: ,po_distributions podist2
225: WHERE rcv_txn2.transaction_id = rcvsub2.rcv_transaction_id
226: and podist2.po_distribution_id = rcv_txn2.po_distribution_id

Line 247: -- G_err_stage := 'UPDATING RCV TRANSACTIONS FOR net_zero_adj_po';

243:
244: -- l_old_stack := G_err_stack;
245: -- G_err_stack := G_err_stack || '->PAAPIMP_PKG.net_zero_adj_po';
246: -- G_err_code := 0;
247: -- G_err_stage := 'UPDATING RCV TRANSACTIONS FOR net_zero_adj_po';
248:
249: -- write_log(LOG, G_err_stack);
250:
251: OPEN net_zero_po_proj (l_rcv_transaction_id);

Line 312: FROM rcv_transactions rcv_txn

308: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
309: AND EXISTS
310: (
311: SELECT 'X'
312: FROM rcv_transactions rcv_txn
313: WHERE rcv_txn.TRANSACTION_ID = rcv_sub.RCV_TRANSACTION_ID
314: AND ((rcv_txn.destination_type_code IN ('INVENTORY','MULTIPLE','SHOP FLOOR')
315: OR
316: (rcv_txn.destination_type_code = 'RECEIVING'

Line 368: FROM Rcv_Transactions rcv_txn, PO_Distributions po_dist

364: WHERE rcv_sub.pa_addition_flag IN ('N','I')
365: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
366: AND EXISTS
367: ( SELECT po_dist.code_combination_id
368: FROM Rcv_Transactions rcv_txn, PO_Distributions po_dist
369: WHERE
370: (
371: (rcv_txn.destination_type_code ='EXPENSE' )
372: OR (rcv_txn.destination_type_code = 'RECEIVING'

Line 600: FROM Rcv_Transactions rcv_txn ,

596: --Cursor to check if there are any Pending Receipts.
597:
598: CURSOR c_pending_receipts(p_po_header_id IN NUMBER) IS
599: SELECT DISTINCT rsh.receipt_num, rsh.creation_date -- Added for the bug 13617899
600: FROM Rcv_Transactions rcv_txn ,
601: rcv_shipment_headers rsh ,
602: PO_Distributions_all po_dist ,
603: rcv_receiving_sub_ledger rcv_sub1
604: WHERE po_dist.po_header_id =p_po_header_id