DBA Data[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PA_TRANSFER_AP_INVOICES_VIEW

Line 457: PA_Transfer_AP_Invoices_View DIST,

453: ,SELF_ASSESSED_FLAG ---Bug 13602288: Self Assessed Tax Changes
454: FROM PO_Vendors VEND,
455: AP_Invoices INV,
456: AP_Invoice_Lines INVL,
457: PA_Transfer_AP_Invoices_View DIST,
458: PA_EXPENDITURE_TYPES TYPE
459: WHERE DIST.Invoice_Id = INV.Invoice_Id
460: AND INVL.Invoice_id = INV.Invoice_Id
461: AND INVL.Line_Number = DIST.Invoice_Line_Number

Line 565: PA_Transfer_AP_Invoices_View DIST,

561: from AP_Invoice_Payments_all pay,
562: po_vendors vend,
563: ap_invoices inv,
564: ap_payment_hist_dists paydist,
565: PA_Transfer_AP_Invoices_View DIST,
566: ap_checks chk
567: where pay.posted_flag='Y'
568: AND pay.invoice_payment_id = paydist.invoice_payment_id
569: AND pay.check_id = chk.check_id

Line 800: PA_Transfer_AP_Invoices_View DIST

796: ,'Y' si_assets_addition_flag
797: ,'Y' insert_flag
798: FROM PO_Vendors VEND,
799: AP_Invoices_all INV,
800: PA_Transfer_AP_Invoices_View DIST
801: WHERE DIST.Invoice_Id = INV.Invoice_Id
802: AND DIST.Pa_Addition_Flag = 'W'
803: AND INV.Vendor_Id = VEND.Vendor_Id
804: AND DIST.request_id = G_REQUEST_ID

Line 1030: --PA_Transfer_AP_Invoices_View DIST1,

1026: AP_Prepay_APP_Dists PDIST,
1027: AP_INVOICE_DISTRIBUTIONS DIST1,
1028: AP_INVOICE_DISTRIBUTIONS DIST2,
1029: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1030: --PA_Transfer_AP_Invoices_View DIST1,
1031: -- PA_Transfer_AP_Invoices_View DIST2,
1032: PA_EXPENDITURE_TYPES TYPE
1033: WHERE DIST1.Invoice_Id = INV.Invoice_Id
1034: AND DIST1.invoice_distribution_id = PDIST.invoice_distribution_id -- Std inv line to which Prepay is applied

Line 1031: -- PA_Transfer_AP_Invoices_View DIST2,

1027: AP_INVOICE_DISTRIBUTIONS DIST1,
1028: AP_INVOICE_DISTRIBUTIONS DIST2,
1029: -- changed from view to table to process the rec tax part of prorated prepay appl for bug#5514129
1030: --PA_Transfer_AP_Invoices_View DIST1,
1031: -- PA_Transfer_AP_Invoices_View DIST2,
1032: PA_EXPENDITURE_TYPES TYPE
1033: WHERE DIST1.Invoice_Id = INV.Invoice_Id
1034: AND DIST1.invoice_distribution_id = PDIST.invoice_distribution_id -- Std inv line to which Prepay is applied
1035: AND DIST2.invoice_id = DIST1.invoice_id