[Home] [Help]
768: sum(ap_pay_hd.amount) Disc_Taken_On_Invoice /* Bug# 7833675 */
769: from
770: ap_invoice_dIstributions_all apd,
771: ap_invoice_dIstributions_all rc_tax,
772: po_dIstributions_all pod,
773: ap_payment_hist_dists ap_pay_hd
774: where apd.project_Id = p_project_Id
775: and rc_tax.line_type_lookup_code(+) = 'REC_TAX'
776: and rc_tax.tax_recoverable_flag(+) = 'Y'
804: from
805: ap_invoices_all aia,
806: ap_invoice_dIstributions_all apd,
807: ap_invoice_dIstributions_all apd1, /* Bug# 8310848 */
808: po_dIstributions_all pod
809: where aia.invoice_id = p_invoice_id
810: and nvl(aia.Cancelled_Date,Sysdate+1) = (Sysdate+1)
811: and aia.invoice_type_lookup_code <> 'RETAINAGE RELEASE'
812: and apd.invoice_id = aia.invoice_id
893: select
894: sum(rc_tax.amount) ProjInv_RCTax_Amount
895: from
896: ap_invoice_dIstributions_all apd,
897: po_dIstributions_all pod,
898: ap_invoice_dIstributions_all rc_tax
899: where apd.project_Id = p_project_Id
900: and apd.invoice_id = p_invoice_id
901: and apd.task_id = p_task_id
1378:
1379: select sum(apd.amount) ProjInvAmount into l_invrec_amount
1380: from ap_invoice_dIstributions_all apd,
1381: ap_invoice_dIstributions_all rc_tax,
1382: po_dIstributions_all pod
1383: where
1384: apd.project_Id = INVDTL.project_Id
1385: and rc_tax.line_type_lookup_code(+) = 'REC_TAX'
1386: and rc_tax.tax_recoverable_flag(+) = 'Y'
1402:
1403: select sum(apd.amount) ProjInvAmount into l_invrec_amount
1404: from ap_invoice_dIstributions_all apd,
1405: ap_invoice_dIstributions_all rc_tax,
1406: po_dIstributions_all pod
1407: where
1408: apd.project_Id = INVDTL.project_Id
1409: and rc_tax.line_type_lookup_code(+) = 'REC_TAX'
1410: and rc_tax.tax_recoverable_flag(+) = 'Y'