APPS.AP_MATCHING_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 1091: FROM po_distributions_ap_v PD

1087: NULL), --expenditure_organization_id
1088: DECODE(PD.destination_type_code,
1089: 'EXPENSE', PD.award_id), --award_id
1090: ap_invoice_distributions_s.nextval
1091: FROM po_distributions_ap_v PD
1092: WHERE line_location_id = x_po_line_location_id;
1093:
1094:
1095: l_total_quantity number;

Line 1249: FROM po_distributions_ap_v

1245: x_dist_tab(i).expenditure_type,
1246: x_dist_tab(i).expenditure_item_date,
1247: x_dist_tab(i).expenditure_organization_id,
1248: x_dist_tab(i).invoice_distribution_id
1249: FROM po_distributions_ap_v
1250: WHERE po_distribution_id = x_dist_tab(i).po_distribution_id;
1251:
1252: -- Bug 5554493
1253: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1489: --po_distributions_ap_v.code_combination_id is accrual account

1485: --bugfix:4668058 added the following clause
1486: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1487: ) THEN
1488:
1489: --po_distributions_ap_v.code_combination_id is accrual account
1490: --if accruing on receipt or else charge account
1491:
1492: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1493:

Line 1663: FROM po_distributions_ap_v PD

1659: )
1660: )
1661: )
1662: INTO X_Total_Quantity
1663: FROM po_distributions_ap_v PD
1664: WHERE line_location_id = X_Po_Line_Location_Id;
1665:
1666: IF(x_total_quantity = 0) THEN
1667: x_total_quantity := 1;

Line 1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V

1728: END IF;
1729:
1730: -- bug 5061826
1731: -- go to base tables PO_LINES_ALL, PO_LINE_LOCATIONS and PO_DISTRIBUTIONS
1732: -- instead of PO_LINE_LOCATIONS_AP_V and PO_DISTRIBUTIONS_AP_V
1733:
1734: INSERT INTO AP_INVOICE_LINES (
1735: INVOICE_ID,
1736: LINE_NUMBER,

Line 2118: PO_DISTRIBUTIONS_AP_V PD,

2114: and msi.organization_id(+) = g_inventory_organization_id
2115: and rownum = 1;
2116: /* -- bug 5061826 -- commented out older FROM clause
2117: FROM PO_LINE_LOCATIONS_AP_V PLL,
2118: PO_DISTRIBUTIONS_AP_V PD,
2119: MTL_SYSTEM_ITEMS MSI
2120: WHERE PLL.LINE_LOCATION_ID = X_PO_LINE_LOCATION_ID
2121: AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
2122: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)