DBA Data[Home] [Help]

APPS.PAAP_PWP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 585: ap_invoice_dIstributions_all apd

581: from ap_invoices_all apinv,
582: ap_payment_schedules_all appay,
583: po_vendors vend
584: where exIsts (select 1 from
585: ap_invoice_dIstributions_all apd
586: where apd.project_id = P_project_Id
587: and apd.posted_flag ='Y'
588: and apinv.invoice_id = apd.invoice_id)
589: and appay.invoice_id(+)=apinv.invoice_id

Line 613: ap_invoice_dIstributions_all apd

609: sum(amount_remaining)/nvl(apinv.exchange_rate,1))),0) Paid_Inv_Amt
610: from ap_invoices_all apinv,
611: ap_payment_schedules_all appay
612: where apinv.invoice_id = p_invoice_id and exIsts (select 1 from
613: ap_invoice_dIstributions_all apd
614: where apd.project_id = P_project_Id
615: and apd.posted_flag ='Y'
616: and apinv.invoice_id = apd.invoice_id)
617: and appay.invoice_id(+)=apinv.invoice_id

Line 650: ap_invoice_dIstributions_all apd,

646: pod.po_header_id,
647: sum(apd.amount) ProjInvAmount,
648: sum(ap_pay_hd.amount) Disc_Taken_On_Invoice /* Bug# 7833675 */
649: from
650: ap_invoice_dIstributions_all apd,
651: po_dIstributions_all pod,
652: ap_payment_hist_dists ap_pay_hd
653: where apd.project_Id = p_project_Id
654: and apd.invoice_id = p_invoice_id

Line 675: ap_invoice_dIstributions_all apd,

671: p_task_id Number,
672: p_Expenditure_Item_Date Date,
673: p_po_header_id Number) Is
674: select sum(apd.amount) ProjRtngAmount from
675: ap_invoice_dIstributions_all apd,
676: po_dIstributions_all pod
677: where apd.project_Id = p_project_Id
678: and apd.invoice_id = p_invoice_id
679: and apd.posted_flag = 'Y'