DBA Data[Home] [Help]

APPS.AP_RCT_AMT_MATCH_PKG dependencies on PO_DISTRIBUTIONS_AP_V

Line 1031: FROM po_distributions_ap_v PD,

1027: NULL), --expenditure_organization_id
1028: DECODE(PD.destination_type_code,
1029: 'EXPENSE', PD.award_id), --award_id
1030: ap_invoice_distributions_s.nextval
1031: FROM po_distributions_ap_v PD,
1032: rcv_transactions RT
1033: WHERE PD.line_location_id = x_po_line_location_id
1034: and Pd.line_location_id = RT.po_line_location_id
1035: and Pd.po_distribution_id = NVL(RT.po_distribution_id, Pd.po_distribution_id) --Added for bug 13845471

Line 1268: FROM po_distributions_ap_v pod

1264: x_dist_tab(i).expenditure_type,
1265: x_dist_tab(i).expenditure_item_date,
1266: x_dist_tab(i).expenditure_organization_id,
1267: x_dist_tab(i).invoice_distribution_id
1268: FROM po_distributions_ap_v pod
1269: ,rcv_transactions RT --Added for bug 13845471
1270: WHERE pod.po_distribution_id = x_dist_tab(i).po_distribution_id
1271: AND pod.po_distribution_id = NVL(rt.po_distribution_id,pod.po_distribution_id) --Added for bug 13845471
1272: AND rt.TRANSACTION_ID= X_Rcv_Transaction_Id; --Added for bug 13845471

Line 1499: --po_distributions_ap_v.code_combination_id is accrual account

1495: --bugfix:4668058 added the following clause
1496: (x_dist_tab(i).project_id IS NOT NULL AND g_allow_pa_override = 'N')
1497: ) THEN
1498:
1499: --po_distributions_ap_v.code_combination_id is accrual account
1500: --if accruing on receipt or else charge account
1501:
1502: x_dist_tab(i).dist_ccid := x_dist_tab(i).po_ccid;
1503:

Line 2277: FROM PO_DISTRIBUTIONS_AP_V PD,

2273: --Modified for bug#13505998 -G_ASSESSABLE_VALUE,
2274: DECODE(X_Amount,l_full_mtch_amt,G_ASSESSABLE_VALUE, NULL),
2275: G_dflt_tax_class_code,
2276: G_PAY_AWT_GROUP_ID --bug 9689194
2277: FROM PO_DISTRIBUTIONS_AP_V PD,
2278: MTL_SYSTEM_ITEMS MSI,
2279: PO_AP_RECEIPT_MATCH_V RCV,
2280: RCV_SHIPMENT_LINES RSL,
2281: RCV_TRANSACTIONS RT --7015553

Line 2971: FROM po_distributions_ap_v pd,

2967: ,'N' --accrual_posted_flag
2968: ,'N' --cash_posted_flag
2969: ,'N' --rcv_charge_addition_flag
2970: ,x_dist_tab(i).pay_awt_group_id --pay_awt_group_id --bug 9689194
2971: FROM po_distributions_ap_v pd,
2972: ap_invoice_lines ail,
2973: po_ap_receipt_match_v rcv,
2974: gl_code_combinations gcc
2975: WHERE ail.invoice_id = x_invoice_id