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 156: from rcv_transactions a, rcv_receiving_sub_ledger c

152: /* If cash basis accounting is implemented then receipts are not interfaced to PA */
153: IF P_CASH_BASIS_ACCTG = 'N' THEN --R12 change ------{
154: Select nvl(Sum(nvl(ENTERED_NR_TAX,0)),0)
155: Into l_RcptNrTaxCosts
156: from rcv_transactions a, rcv_receiving_sub_ledger c
157: where a.po_distribution_id = p_po_dist
158: and ((a.destination_type_code = 'EXPENSE' ) or
159: (a.destination_type_code = 'RECEIVING' and
160: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))

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

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

Line 287: rcv_receiving_sub_ledger c

283: 'I',
284: (nvl(c.entered_dr,0)-nvl(c.entered_cr,0)-nvl(c.entered_nr_tax,0))))))
285: into l_rcpt_qty
286: from rcv_transactions a,
287: rcv_receiving_sub_ledger c
288: where a.po_distribution_id = p_po_dist
289: and ((a.destination_type_code = 'EXPENSE') or
290: (a.destination_type_code = 'RECEIVING' and
291: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))

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

322: where a.po_distribution_id = p_po_dist
323: and ((a.destination_type_code = 'EXPENSE' ) or
324: (a.destination_type_code = 'RECEIVING' and
325: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))
326: and EXISTS ( SELECT /*+ Index(rcv_sub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_sub.rcv_transaction_id
327: FROM rcv_receiving_sub_ledger rcv_sub
328: WHERE rcv_sub.rcv_transaction_id = a.transaction_id
329: AND rcv_sub.pa_addition_flag in ('Y', 'I'));
330: END IF; /* IF is_eib_item...*/

Line 327: FROM rcv_receiving_sub_ledger rcv_sub

323: and ((a.destination_type_code = 'EXPENSE' ) or
324: (a.destination_type_code = 'RECEIVING' and
325: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))
326: and EXISTS ( SELECT /*+ Index(rcv_sub RCV_RECEIVING_SUB_LEDGER_N1) */ rcv_sub.rcv_transaction_id
327: FROM rcv_receiving_sub_ledger rcv_sub
328: WHERE rcv_sub.rcv_transaction_id = a.transaction_id
329: AND rcv_sub.pa_addition_flag in ('Y', 'I'));
330: END IF; /* IF is_eib_item...*/
331: END IF;

Line 540: from rcv_transactions a, rcv_receiving_sub_ledger c

536: select sum(decode(c.pa_addition_flag, 'Y', (nvl(accounted_dr,0)-nvl(accounted_cr,0)),
537: 'I', ((nvl(accounted_dr,0)-nvl(accounted_cr,0))-(nvl(accounted_nr_tax,0))
538: )))
539: into l_rcpt_amt
540: from rcv_transactions a, rcv_receiving_sub_ledger c
541: where a.po_distribution_id = p_po_dist
542: and ((a.destination_type_code = 'EXPENSE' ) or
543: (a.destination_type_code = 'RECEIVING' and
544: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))

Line 555: from rcv_transactions a, rcv_receiving_sub_ledger c

551: select sum(decode(c.pa_addition_flag, 'Y', (nvl(entered_dr,0)-nvl(entered_cr,0)),
552: 'I', ((nvl(entered_dr,0)-nvl(entered_cr,0))-(nvl(entered_nr_tax,0))
553: )))
554: into l_rcpt_amt
555: from rcv_transactions a, rcv_receiving_sub_ledger c
556: where a.po_distribution_id = p_po_dist
557: and ((a.destination_type_code = 'EXPENSE' ) or
558: (a.destination_type_code = 'RECEIVING' and
559: a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))