APPS.AP_RCT_AMT_MATCH_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 933: FROM po_distributions_ap_v PD,

929: NULL), --expenditure_organization_id
930: DECODE(PD.destination_type_code,
931: 'EXPENSE', PD.award_id), --award_id
932: ap_invoice_distributions_s.nextval
933: FROM po_distributions_ap_v PD,
934: rcv_transactions RT
935: WHERE PD.line_location_id = x_po_line_location_id
936: and Pd.line_location_id = RT.po_line_location_id
937: and RT.TRANSACTION_ID= X_Rcv_Transaction_Id ;

Line 1160: FROM po_distributions_ap_v

1156: x_dist_tab(i).expenditure_type,
1157: x_dist_tab(i).expenditure_item_date,
1158: x_dist_tab(i).expenditure_organization_id,
1159: x_dist_tab(i).invoice_distribution_id
1160: FROM po_distributions_ap_v
1161: WHERE po_distribution_id = x_dist_tab(i).po_distribution_id;
1162:
1163: -- Bug 5554493
1164: x_dist_tab(i).pa_quantity := x_dist_tab(i).quantity_invoiced;

Line 1386: --po_distributions_ap_v.code_combination_id is accrual account

1382: --bugfix:4668058 added the following clause
1383: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1384: ) THEN
1385:
1386: --po_distributions_ap_v.code_combination_id is accrual account
1387: --if accruing on receipt or else charge account
1388:
1389: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1390:

Line 2147: FROM PO_DISTRIBUTIONS_AP_V PD,

2143: G_PRODUCT_CATEGORY, --product_category
2144: G_USER_DEFINED_FISC_CLASS, --user_defined_fisc_class
2145: G_ASSESSABLE_VALUE,
2146: G_dflt_tax_class_code
2147: FROM PO_DISTRIBUTIONS_AP_V PD,
2148: MTL_SYSTEM_ITEMS MSI,
2149: PO_AP_RECEIPT_MATCH_V RCV,
2150: RCV_SHIPMENT_LINES RSL,
2151: RCV_TRANSACTIONS RT --7015553

Line 2809: FROM po_distributions_ap_v pd,

2805: g_intended_use --intended_use
2806: ,'N' --accrual_posted_flag
2807: ,'N' --cash_posted_flag
2808: ,'N' --rcv_charge_addition_flag
2809: FROM po_distributions_ap_v pd,
2810: ap_invoice_lines ail,
2811: po_ap_receipt_match_v rcv,
2812: gl_code_combinations gcc
2813: WHERE ail.invoice_id = x_invoice_id