[Home] [Help]
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')))
276: (nvl(c.entered_dr,0)-nvl(c.entered_cr,0)),
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
293: IF (Is_eIB_item(p_po_dist) = 'Y' AND g_accrue_on_receipt_flag = 'N') THEN
294:
295: select sum(decode(destination_type_code, 'EXPENSE', decode(transaction_type,'RETURN TO RECEIVING',-1 * quantity, quantity),'RECEIVING',-1 * quantity))
296: into l_rcpt_qty
297: from rcv_transactions a
298: where a.po_distribution_id = p_po_dist
299: and ((a.destination_type_code = 'EXPENSE' ) or
300: (a.destination_type_code = 'RECEIVING' and a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))
301: and a.pa_addition_flag in ('Y','I') ;
311: quantity),
312: 'RECEIVING',
313: -1 * quantity))
314: into l_rcpt_qty
315: from rcv_transactions a
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')))
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')))
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')))