APPS.AP_MATCHING_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 1172: FROM po_distributions_ap_v PD

1168: NULL), --expenditure_organization_id
1169: DECODE(PD.destination_type_code,
1170: 'EXPENSE', PD.award_id), --award_id
1171: ap_invoice_distributions_s.nextval
1172: FROM po_distributions_ap_v PD
1173: WHERE line_location_id = x_po_line_location_id;
1174:
1175:
1176: l_total_quantity number;

Line 1334: FROM po_distributions_ap_v

1330: x_dist_tab(i).expenditure_type,
1331: x_dist_tab(i).expenditure_item_date,
1332: x_dist_tab(i).expenditure_organization_id,
1333: x_dist_tab(i).invoice_distribution_id
1334: FROM po_distributions_ap_v
1335: WHERE po_distribution_id = x_dist_tab(i).po_distribution_id;
1336:
1337: -- Bug 5554493
1338: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1575: --po_distributions_ap_v.code_combination_id is accrual account

1571: --bugfix:4668058 added the following clause
1572: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1573: ) THEN
1574:
1575: --po_distributions_ap_v.code_combination_id is accrual account
1576: --if accruing on receipt or else charge account
1577:
1578: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1579:

Line 1749: FROM po_distributions_ap_v PD

1745: )
1746: )
1747: )
1748: INTO X_Total_Quantity
1749: FROM po_distributions_ap_v PD
1750: WHERE line_location_id = X_Po_Line_Location_Id;
1751:
1752: IF(x_total_quantity = 0) THEN
1753: x_total_quantity := 1;

Line 1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1827: --End Bug#13505998
1828:
1829: -- bug 5061826
1830: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1831: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1832:
1833: INSERT INTO AP_INVOICE_LINES (
1834: INVOICE_ID,
1835: LINE_NUMBER,

Line 2218: PO_DISTRIBUTIONS_AP_V PD,

2214: and msi.organization_id(+) = g_inventory_organization_id
2215: and rownum = 1;
2216: /* -- bug 5061826 -- commented out older FROM clause
2217: FROM PO_LINE_LOCATIONS_AP_V PLL,
2218: PO_DISTRIBUTIONS_AP_V PD,
2219: MTL_SYSTEM_ITEMS MSI
2220: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2221: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
2222: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)