APPS.AP_PO_AMT_MATCH_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 1036: FROM po_distributions_ap_v PD

1032: NULL), --expenditure_organization_id
1033: DECODE(PD.destination_type_code,
1034: 'EXPENSE', PD.award_id), --award_id
1035: ap_invoice_distributions_s.nextval
1036: FROM po_distributions_ap_v PD
1037: WHERE line_location_id = x_po_line_location_id;
1038:
1039: l_total_amount number;
1040: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

Line 1171: FROM po_distributions_ap_v

1167: x_dist_tab(i).expenditure_type,
1168: x_dist_tab(i).expenditure_item_date,
1169: x_dist_tab(i).expenditure_organization_id,
1170: x_dist_tab(i).invoice_distribution_id
1171: FROM po_distributions_ap_v
1172: WHERE po_distribution_id = x_dist_tab(i).po_distribution_id;
1173:
1174: -- Bug 5554493
1175: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1396: --po_distributions_ap_v.code_combination_id is accrual account

1392: --bugfix:4668058 added the following clause
1393: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1394: ) THEN
1395:
1396: --po_distributions_ap_v.code_combination_id is accrual account
1397: --if accruing on receipt or else charge account
1398:
1399: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1400:

Line 1537: FROM po_distributions_ap_v

1533: ,0)),
1534: DECODE(distribution_type,'PREPAYMENT',
1535: NVL(amount_financed,0),NVL(amount_billed, 0))))
1536: INTO X_Total_Amount
1537: FROM po_distributions_ap_v
1538: WHERE line_location_id = X_Po_Line_Location_Id;
1539:
1540: EXCEPTION
1541: WHEN OTHERS THEN

Line 1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1779: --End Bug#13505998
1780:
1781: -- perf bug 5058993
1782: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1783: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1784:
1785:
1786: INSERT INTO AP_INVOICE_LINES (
1787: INVOICE_ID,

Line 2173: PO_DISTRIBUTIONS_AP_V PD,

2169: and msi.organization_id(+) = g_inventory_organization_id
2170: and rownum = 1;
2171: /* -- commented out older from clause below
2172: FROM PO_LINE_LOCATIONS_AP_V PLL,
2173: PO_DISTRIBUTIONS_AP_V PD,
2174: MTL_SYSTEM_ITEMS MSI
2175: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2176: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
2177: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)