APPS.AP_PO_AMT_MATCH_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 938: FROM po_distributions_ap_v PD

934: NULL), --expenditure_organization_id
935: DECODE(PD.destination_type_code,
936: 'EXPENSE', PD.award_id), --award_id
937: ap_invoice_distributions_s.nextval
938: FROM po_distributions_ap_v PD
939: WHERE line_location_id = x_po_line_location_id;
940:
941: l_total_amount number;
942: l_po_distribution_id po_distributions_all.po_distribution_id%TYPE;

Line 1072: FROM po_distributions_ap_v

1068: x_dist_tab(i).expenditure_type,
1069: x_dist_tab(i).expenditure_item_date,
1070: x_dist_tab(i).expenditure_organization_id,
1071: x_dist_tab(i).invoice_distribution_id
1072: FROM po_distributions_ap_v
1073: WHERE po_distribution_id = x_dist_tab(i).po_distribution_id;
1074:
1075: -- Bug 5554493
1076: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1295: --po_distributions_ap_v.code_combination_id is accrual account

1291: --bugfix:4668058 added the following clause
1292: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1293: ) THEN
1294:
1295: --po_distributions_ap_v.code_combination_id is accrual account
1296: --if accruing on receipt or else charge account
1297:
1298: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1299:

Line 1436: FROM po_distributions_ap_v

1432: ,0)),
1433: DECODE(distribution_type,'PREPAYMENT',
1434: NVL(amount_financed,0),NVL(amount_billed, 0))))
1435: INTO X_Total_Amount
1436: FROM po_distributions_ap_v
1437: WHERE line_location_id = X_Po_Line_Location_Id;
1438:
1439: EXCEPTION
1440: WHEN OTHERS THEN

Line 1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1663: l_debug_info := 'Inserting Item Line Matched to a PO';
1664:
1665: -- perf bug 5058993
1666: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1667: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1668:
1669:
1670: INSERT INTO AP_INVOICE_LINES (
1671: INVOICE_ID,

Line 2054: PO_DISTRIBUTIONS_AP_V PD,

2050: and msi.organization_id(+) = g_inventory_organization_id
2051: and rownum = 1;
2052: /* -- commented out older from clause below
2053: FROM PO_LINE_LOCATIONS_AP_V PLL,
2054: PO_DISTRIBUTIONS_AP_V PD,
2055: MTL_SYSTEM_ITEMS MSI
2056: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2057: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
2058: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)