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_CMT_UTILS dependencies on RCV_RECEIVING_SUB_LEDGER

Line 141: from rcv_transactions a, rcv_receiving_sub_ledger c

137: /* If cash basis accounting is implemented then receipts are not interfaced to PA */
138: IF P_CASH_BASIS_ACCTG = 'N' THEN --R12 change ------{
139: Select nvl(Sum(nvl(ENTERED_NR_TAX,0)),0)
140: Into l_RcptNrTaxCosts
141: from rcv_transactions a, rcv_receiving_sub_ledger c
142: where a.po_distribution_id = p_po_dist
143: and ((a.destination_type_code = 'EXPENSE' ) or
144: (a.destination_type_code = 'RECEIVING' and
145: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))

Line 259: select /+ Index(c RCV_RECEIVING_SUB_LEDGER_N1) /sum(decode(a.destination_type_code,

255:
256: /* This is an amount based PO and so quantity will be the same as the amount */
257:
258: /* Added index hint as part of bug 6408874 */
259: select /*+ Index(c RCV_RECEIVING_SUB_LEDGER_N1) */sum(decode(a.destination_type_code,
260: 'EXPENSE',
261: decode(transaction_type,
262: 'RETURN TO RECEIVING',
263: -1 * (decode(c.pa_addition_flag,

Line 281: rcv_receiving_sub_ledger c

277: 'I',
278: (nvl(c.entered_dr,0)-nvl(c.entered_cr,0)-nvl(c.entered_nr_tax,0))))))
279: into l_rcpt_qty
280: from rcv_transactions a,
281: rcv_receiving_sub_ledger c
282: where a.po_distribution_id = p_po_dist
283: and ((a.destination_type_code = 'EXPENSE') or
284: (a.destination_type_code = 'RECEIVING' and
285: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))

Line 320: and EXISTS ( SELECT /+ Index(rcv_sub RCV_RECEIVING_SUB_LEDGER_N1) / rcv_sub.rcv_transaction_id

316: where a.po_distribution_id = p_po_dist
317: and ((a.destination_type_code = 'EXPENSE' ) or
318: (a.destination_type_code = 'RECEIVING' and
319: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))
320: and EXISTS ( SELECT /*+ Index(rcv_sub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_sub.rcv_transaction_id
321: FROM rcv_receiving_sub_ledger rcv_sub
322: WHERE rcv_sub.rcv_transaction_id = a.transaction_id
323: AND rcv_sub.pa_addition_flag in ('Y', 'I'));
324: END IF; /* IF is_eib_item...*/

Line 321: FROM rcv_receiving_sub_ledger rcv_sub

317: and ((a.destination_type_code = 'EXPENSE' ) or
318: (a.destination_type_code = 'RECEIVING' and
319: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))
320: and EXISTS ( SELECT /*+ Index(rcv_sub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_sub.rcv_transaction_id
321: FROM rcv_receiving_sub_ledger rcv_sub
322: WHERE rcv_sub.rcv_transaction_id = a.transaction_id
323: AND rcv_sub.pa_addition_flag in ('Y', 'I'));
324: END IF; /* IF is_eib_item...*/
325: END IF;

Line 471: from rcv_transactions a, rcv_receiving_sub_ledger c

467: select sum(decode(c.pa_addition_flag, 'Y', (nvl(accounted_dr,0)-nvl(accounted_cr,0)),
468: 'I', ((nvl(accounted_dr,0)-nvl(accounted_cr,0))-(nvl(accounted_nr_tax,0))
469: )))
470: into l_rcpt_amt
471: from rcv_transactions a, rcv_receiving_sub_ledger c
472: where a.po_distribution_id = p_po_dist
473: and ((a.destination_type_code = 'EXPENSE' ) or
474: (a.destination_type_code = 'RECEIVING' and
475: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))

Line 486: from rcv_transactions a, rcv_receiving_sub_ledger c

482: select sum(decode(c.pa_addition_flag, 'Y', (nvl(entered_dr,0)-nvl(entered_cr,0)),
483: 'I', ((nvl(entered_dr,0)-nvl(entered_cr,0))-(nvl(entered_nr_tax,0))
484: )))
485: into l_rcpt_amt
486: from rcv_transactions a, rcv_receiving_sub_ledger c
487: where a.po_distribution_id = p_po_dist
488: and ((a.destination_type_code = 'EXPENSE' ) or
489: (a.destination_type_code = 'RECEIVING' and
490: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))