APPS.AP_RECT_MATCH_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 1101: FROM po_distributions_ap_v PD,

1097: NULL), --expenditure_organization_id
1098: DECODE(PD.destination_type_code,
1099: 'EXPENSE', PD.award_id), --award_id
1100: ap_invoice_distributions_s.nextval
1101: FROM po_distributions_ap_v PD,
1102: rcv_transactions RT
1103: WHERE PD.line_location_id = x_po_line_location_id
1104: and Pd.line_location_id = RT.po_line_location_id
1105: and Pd.po_distribution_id = NVL(RT.po_distribution_id, Pd.po_distribution_id) -- bug 8771037

Line 1406: FROM po_distributions_ap_v pd

1402: x_dist_tab(i).expenditure_type,
1403: x_dist_tab(i).expenditure_item_date,
1404: x_dist_tab(i).expenditure_organization_id,
1405: x_dist_tab(i).invoice_distribution_id
1406: FROM po_distributions_ap_v pd
1407: ,rcv_transactions RT --Added for bug 13845471
1408: WHERE pd.po_distribution_id = x_dist_tab(i).po_distribution_id
1409: AND pd.po_distribution_id = NVL(rt.po_distribution_id,pd.po_distribution_id) --Added for bug 13845471
1410: AND rt.TRANSACTION_ID= X_Rcv_Transaction_Id; --Added for bug 13845471

Line 1650: --po_distributions_ap_v.code_combination_id is accrual account

1646: --bugfix:4668058 added the following clause
1647: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1648: ) THEN
1649:
1650: --po_distributions_ap_v.code_combination_id is accrual account
1651: --if accruing on receipt or else charge account
1652:
1653: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1654:

Line 2322: FROM PO_DISTRIBUTIONS_AP_V PD,

2318: --Modified for bug#13505998 G_ASSESSABLE_VALUE,
2319: DECODE(X_Amount,l_full_mtch_amt,G_ASSESSABLE_VALUE, NULL),
2320: G_dflt_tax_class_code,
2321: G_PAY_AWT_GROUP_ID --bug 9689194
2322: FROM PO_DISTRIBUTIONS_AP_V PD,
2323: MTL_SYSTEM_ITEMS MSI,
2324: PO_AP_RECEIPT_MATCH_V RCV,
2325: RCV_SHIPMENT_LINES RSL,
2326: RCV_TRANSACTIONS RT --for 7015553