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_RECEIVING_SUB_LEDGER

Line 30: rcv_receiving_sub_ledger rcv_sub

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')
34: and ((rcv_txn.destination_type_code ='EXPENSE') OR

Line 55: rcv_receiving_sub_ledger rcv_sub

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*/
59: and rcv_sub.code_combination_id = podist.code_combination_id/*Bug 3905697*/

Line 93: rcv_receiving_sub_ledger rcv_sub

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*/
97: and rcv_sub.code_combination_id = podist.code_combination_id/*Bug 3905697*/

Line 169: rcv_receiving_sub_ledger table. This API will be called from

165:
166:
167: --Added for bug 4407908
168: /*This is a public API, which will update PA_ADDITION_FLAG in
169: rcv_receiving_sub_ledger table. This API will be called from
170: purchasing module at the time of receipt creation.*/
171:
172: PROCEDURE Update_PA_Addition_Flg (p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

Line 185: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;

181: p_accounting_event_id IN NUMBER)
182: IS
183: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */
184: l_po_distribution_id po_distributions_all.po_distribution_id%type;
185: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;
186: l_processed Number := 0;
187:
188: PROCEDURE net_zero_adj_po IS
189:

Line 201: SELECT /+ leading(rcv_txn) index(rcvsub RCV_RECEIVING_SUB_LEDGER_N1) / rcv_txn.transaction_id /4338075/

197: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
198:
199:
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

Line 206: ,rcv_receiving_sub_ledger rcvsub

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
209: FROM rcv_transactions rcv_txn3
210: WHERE rcv_txn3.transaction_id = p_transaction_id)

Line 223: ,rcv_receiving_sub_ledger rcvsub2

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
227: and podist2.code_combination_id = rcvsub2.code_combination_id

Line 265: UPDATE rcv_receiving_sub_ledger rcv_sub

261: IF l_rcv_txn_id_tbl.COUNT <> 0 THEN
262:
263: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
264:
265: UPDATE rcv_receiving_sub_ledger rcv_sub
266: SET rcv_sub.pa_addition_flag = 'Z'
267: WHERE rcv_sub.rcv_transaction_id = l_rcv_txn_id_tbl(i) --pricing changes
268: AND rcv_sub.pa_addition_flag = 'N'
269: AND (rcv_sub.accounting_event_id = l_rcv_acct_evt_tbl(i) --pricing changes

Line 305: UPDATE rcv_receiving_sub_ledger rcv_sub

301: l_po_distribution_id := p_po_distribution_id;
302: l_rcv_transaction_id := p_rcv_transaction_id;
303:
304:
305: UPDATE rcv_receiving_sub_ledger rcv_sub
306: SET rcv_sub.pa_addition_flag = NULL
307: WHERE rcv_sub.pa_addition_flag ='N'
308: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
309: AND EXISTS

Line 362: UPDATE rcv_receiving_sub_ledger rcv_sub

358: );
359:
360: l_processed := SQL%ROWCOUNT ;
361:
362: UPDATE rcv_receiving_sub_ledger rcv_sub
363: SET rcv_sub.pa_Addition_Flag = 'X'
364: WHERE rcv_sub.pa_addition_flag IN ('N','I')
365: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
366: AND EXISTS

Line 603: rcv_receiving_sub_ledger rcv_sub1

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
605: AND rcv_txn.destination_type_code ='EXPENSE'
606: AND rcv_txn.PO_DISTRIBUTION_ID = po_dist.po_distribution_id
607: AND rcv_sub1.code_combination_id = po_dist.code_combination_id