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 28: from rcv_transactions rcv_txn,

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

Line 51: (SELECT 1 FROM rcv_transactions rcv_txn,

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

Line 88: (SELECT 1 FROM rcv_transactions rcv_txn,

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

Line 166: FROM rcv_transactions rcv_txn

162: CURSOR net_zero_po_proj (p_transaction_id IN number) IS /* Modified the cursor query for Bug 5585218 */
163: SELECT /*+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_txn.transaction_id /*4338075*/
164: ,rcv_txn.po_distribution_id
165: ,rcvsub.accounting_event_id -- pricing changes
166: FROM rcv_transactions rcv_txn
167: ,po_distributions podist
168: ,rcv_receiving_sub_ledger rcvsub
169: WHERE rcv_txn.transaction_id = rcvsub.rcv_transaction_id
170: AND rcv_txn.parent_transaction_id = (SELECT parent_transaction_id

Line 171: FROM rcv_transactions rcv_txn3

167: ,po_distributions podist
168: ,rcv_receiving_sub_ledger rcvsub
169: WHERE rcv_txn.transaction_id = rcvsub.rcv_transaction_id
170: AND rcv_txn.parent_transaction_id = (SELECT parent_transaction_id
171: FROM rcv_transactions rcv_txn3
172: WHERE rcv_txn3.transaction_id = p_transaction_id)
173: and rcv_txn.po_distribution_id = podist.po_distribution_id
174: and podist.code_combination_id = rcvsub.code_combination_id
175: and rcvsub.actual_flag = 'A'

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

179: and ((rcv_txn.destination_type_code = 'EXPENSE' ) OR
180: (rcv_txn.destination_type_code = 'RECEIVING' AND
181: rcv_txn.transaction_type in ('RETURN TO VENDOR','RETURN TO RECEIVING')
182: ))
183: and 0 = (SELECT /*+ INDEX(RCV_TXN2 RCV_TRANSACTIONS_N1) */sum(nvl(rcvsub2.entered_dr,0)-nvl(rcvsub2.entered_cr,0))/*4338075*/
184: FROM rcv_transactions rcv_txn2
185: ,rcv_receiving_sub_ledger rcvsub2
186: ,po_distributions podist2
187: WHERE rcv_txn2.transaction_id = rcvsub2.rcv_transaction_id

Line 184: FROM rcv_transactions rcv_txn2

180: (rcv_txn.destination_type_code = 'RECEIVING' AND
181: rcv_txn.transaction_type in ('RETURN TO VENDOR','RETURN TO RECEIVING')
182: ))
183: and 0 = (SELECT /*+ INDEX(RCV_TXN2 RCV_TRANSACTIONS_N1) */sum(nvl(rcvsub2.entered_dr,0)-nvl(rcvsub2.entered_cr,0))/*4338075*/
184: FROM rcv_transactions rcv_txn2
185: ,rcv_receiving_sub_ledger rcvsub2
186: ,po_distributions podist2
187: WHERE rcv_txn2.transaction_id = rcvsub2.rcv_transaction_id
188: and podist2.po_distribution_id = rcv_txn2.po_distribution_id

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

205:
206: -- l_old_stack := G_err_stack;
207: -- G_err_stack := G_err_stack || '->PAAPIMP_PKG.net_zero_adj_po';
208: -- G_err_code := 0;
209: -- G_err_stage := 'UPDATING RCV TRANSACTIONS FOR net_zero_adj_po';
210:
211: -- write_log(LOG, G_err_stack);
212:
213: OPEN net_zero_po_proj (l_rcv_transaction_id);

Line 274: FROM rcv_transactions rcv_txn

270: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
271: AND EXISTS
272: (
273: SELECT 'X'
274: FROM rcv_transactions rcv_txn
275: WHERE rcv_txn.TRANSACTION_ID = rcv_sub.RCV_TRANSACTION_ID
276: AND ((rcv_txn.destination_type_code IN ('INVENTORY','MULTIPLE','SHOP FLOOR')
277: OR
278: (rcv_txn.destination_type_code = 'RECEIVING'

Line 330: FROM Rcv_Transactions rcv_txn, PO_Distributions po_dist

326: WHERE rcv_sub.pa_addition_flag IN ('N','I')
327: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
328: AND EXISTS
329: ( SELECT po_dist.code_combination_id
330: FROM Rcv_Transactions rcv_txn, PO_Distributions po_dist
331: WHERE
332: (
333: (rcv_txn.destination_type_code ='EXPENSE' )
334: OR (rcv_txn.destination_type_code = 'RECEIVING'