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 29: rcv_receiving_sub_ledger rcv_sub

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

Line 52: rcv_receiving_sub_ledger rcv_sub

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

Line 89: rcv_receiving_sub_ledger rcv_sub

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

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

127: End Allow_Project_Info_Change;
128:
129: --Added for bug 4407908
130: /*This is a public API, which will update PA_ADDITION_FLAG in
131: rcv_receiving_sub_ledger table. This API will be called from
132: purchasing module at the time of receipt creation.*/
133:
134: PROCEDURE Update_PA_Addition_Flg (p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,

Line 147: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;

143: p_accounting_event_id IN NUMBER)
144: IS
145: /*l_project_id po_distributions_all.project_id%type; Bug 5585218 */
146: l_po_distribution_id po_distributions_all.po_distribution_id%type;
147: l_rcv_transaction_id rcv_receiving_sub_ledger.rcv_transaction_id%type;
148: l_processed Number := 0;
149:
150: PROCEDURE net_zero_adj_po IS
151:

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

159: l_rcv_acct_evt_tbl PA_PLSQL_DATATYPES.IdTabTyp; -- pricing changes
160:
161:
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

Line 168: ,rcv_receiving_sub_ledger rcvsub

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

Line 185: ,rcv_receiving_sub_ledger rcvsub2

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

Line 227: UPDATE rcv_receiving_sub_ledger rcv_sub

223: IF l_rcv_txn_id_tbl.COUNT <> 0 THEN
224:
225: FORALL i IN l_rcv_txn_id_tbl.FIRST..l_rcv_txn_id_tbl.LAST
226:
227: UPDATE rcv_receiving_sub_ledger rcv_sub
228: SET rcv_sub.pa_addition_flag = 'Z'
229: WHERE rcv_sub.rcv_transaction_id = l_rcv_txn_id_tbl(i) --pricing changes
230: AND rcv_sub.pa_addition_flag = 'N'
231: AND (rcv_sub.accounting_event_id = l_rcv_acct_evt_tbl(i) --pricing changes

Line 267: UPDATE rcv_receiving_sub_ledger rcv_sub

263: l_po_distribution_id := p_po_distribution_id;
264: l_rcv_transaction_id := p_rcv_transaction_id;
265:
266:
267: UPDATE rcv_receiving_sub_ledger rcv_sub
268: SET rcv_sub.pa_addition_flag = NULL
269: WHERE rcv_sub.pa_addition_flag ='N'
270: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
271: AND EXISTS

Line 324: UPDATE rcv_receiving_sub_ledger rcv_sub

320: );
321:
322: l_processed := SQL%ROWCOUNT ;
323:
324: UPDATE rcv_receiving_sub_ledger rcv_sub
325: SET rcv_sub.pa_Addition_Flag = 'X'
326: WHERE rcv_sub.pa_addition_flag IN ('N','I')
327: AND rcv_sub.rcv_transaction_id = l_rcv_transaction_id
328: AND EXISTS