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.PAAP_PWP_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 688: ap_invoice_dIstributions_all apd

684: from ap_invoices_all apinv,
685: ap_payment_schedules_all appay,
686: po_vendors vend
687: where exIsts (select 1 from
688: ap_invoice_dIstributions_all apd
689: where apd.project_id = P_project_Id
690: and apd.posted_flag ='Y'
691: and apinv.invoice_id = apd.invoice_id)
692: and appay.invoice_id(+)=apinv.invoice_id

Line 709: ap_invoice_dIstributions_all apd

705: -- This cursor is to reduce the retainage amount from invoice amount.
706: Cursor C1_Rtng(p_Invoice_Id Number) Is
707: select nvl(sum(apd.amount),0) InvRtngAmount from
708: ap_invoices_all aia,
709: ap_invoice_dIstributions_all apd
710: where aia.invoice_id = p_invoice_id
711: and nvl(aia.Cancelled_Date,Sysdate+1) = (Sysdate+1)
712: and apd.invoice_id = aia.invoice_id
713: and aia.invoice_type_lookup_code <> 'RETAINAGE RELEASE'

Line 731: ap_invoice_dIstributions_all apd

727: sum(amount_remaining)/nvl(appay.payment_cross_rate,1))),0) Paid_Inv_Amt
728: from ap_invoices_all apinv,
729: ap_payment_schedules_all appay
730: where apinv.invoice_id = p_invoice_id and exIsts (select 1 from
731: ap_invoice_dIstributions_all apd
732: where apd.project_id = P_project_Id
733: and apd.posted_flag ='Y'
734: and apinv.invoice_id = apd.invoice_id)
735: and appay.invoice_id(+)=apinv.invoice_id

Line 770: ap_invoice_dIstributions_all apd,

766: /*bug#13614733*/
767: sum(nvl(rc_tax.amount,0)) rc_tax,
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

Line 771: ap_invoice_dIstributions_all rc_tax,

767: sum(nvl(rc_tax.amount,0)) rc_tax,
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'

Line 806: ap_invoice_dIstributions_all apd,

802: -- sum(retained_amount_remaining) Outstanding_Retained
803: sum(apd1.amount) RtngReleaseAmount
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)

Line 807: ap_invoice_dIstributions_all apd1, /* Bug# 8310848 */

803: sum(apd1.amount) RtngReleaseAmount
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'

Line 896: ap_invoice_dIstributions_all apd,

892: p_expenditure_item_date Date, p_po_header_id Number ) Is
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

Line 898: ap_invoice_dIstributions_all rc_tax

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
902: and apd.expenditure_item_date = p_expenditure_item_date

Line 930: ap_invoice_dIstributions_all apd

926: app.exchange_rate
927: from ap_invoices_all app where app.invoice_id=p_invoice_id
928: and
929: exists (select 1 from
930: ap_invoice_dIstributions_all apd
931: where apd.project_id = P_project_Id
932: and apd.posted_flag ='Y'
933: and apd.invoice_id=p_invoice_id);
934:

Line 938: select sum(dist.amount) prepaid_amount from ap_prepay_app_dists dist, ap_invoice_dIstributions_all apd

934:
935:
936: -- Cursor to get prepaid amount
937: Cursor c_prepay_amt(p_invoice_id Number) is
938: select sum(dist.amount) prepaid_amount from ap_prepay_app_dists dist, ap_invoice_dIstributions_all apd
939: where dist.invoice_distribution_id = apd.invoice_distribution_id
940: and apd.project_id=P_Project_Id
941: and apd.invoice_id=p_invoice_id
942: group by apd.invoice_id;

Line 1380: from ap_invoice_dIstributions_all apd,

1376: IF (INVDTL.po_header_id IS NOT NULL ) THEN
1377: --{
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

Line 1381: ap_invoice_dIstributions_all rc_tax,

1377: --{
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'

Line 1404: from ap_invoice_dIstributions_all apd,

1400: ELSE
1401: --{
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

Line 1405: ap_invoice_dIstributions_all rc_tax,

1401: --{
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'