[Home] [Help]
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')))
282: (nvl(c.entered_dr,0)-nvl(c.entered_cr,0)),
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
299: IF (Is_eIB_item(p_po_dist) = 'Y' AND g_accrue_on_receipt_flag = 'N') THEN
300:
301: select sum(decode(destination_type_code, 'EXPENSE', decode(transaction_type,'RETURN TO RECEIVING',-1 * quantity, quantity),'RECEIVING',-1 * quantity))
302: into l_rcpt_qty
303: from rcv_transactions a
304: where a.po_distribution_id = p_po_dist
305: and ((a.destination_type_code = 'EXPENSE' ) or
306: (a.destination_type_code = 'RECEIVING' and a.transaction_type in ('RETURN TO RECEIVING' , 'RETURN TO VENDOR')))
307: and a.pa_addition_flag in ('Y','I') ;
317: quantity),
318: 'RECEIVING',
319: -1 * quantity))
320: into l_rcpt_qty
321: from rcv_transactions a
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')))
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')))
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')))