eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_QUICK_CREDIT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 60: IS TABLE OF ap_invoice_distributions_all.dist_code_combination_id%TYPE;

56: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
57:
58:
59: TYPE dist_ccid_list_tab
60: IS TABLE OF ap_invoice_distributions_all.dist_code_combination_id%TYPE;
61: l_dist_ccid_list dist_ccid_list_tab;
62: l_return_var BOOLEAN := TRUE;
63:
64: BEGIN

Line 211: FROM ap_invoice_distributions_all aid

207: IF (l_return_var = TRUE) THEN
208: BEGIN
209: SELECT DISTINCT aid.dist_code_combination_id
210: BULK COLLECT INTO l_dist_ccid_list
211: FROM ap_invoice_distributions_all aid
212: WHERE aid.invoice_id = P_Invoice_Lines_Tab(i).invoice_id
213: AND aid.invoice_line_number = P_Invoice_Lines_Tab(i).line_number
214: AND NVL(aid.reversal_flag, 'N') <> 'Y';
215:

Line 321: FROM ap_invoice_distributions aid

317: null rounding_amt, --will be populated by the corr API
318: aid.unit_price unit_price,
319: null pa_quantity,
320: aid.dist_code_combination_id dist_ccid
321: FROM ap_invoice_distributions aid
322: WHERE aid.invoice_id = c_invoice_id
323: AND aid.invoice_line_number = c_line_number
324: AND line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TERV',
325: 'TRV', 'IPV', 'ERV')

Line 341: FROM ap_invoice_distributions aid

337: null rounding_amt, --will be populated by the corr API
338: aid.unit_price unit_price,
339: null pa_quantity,
340: aid.dist_code_combination_id dist_ccid
341: FROM ap_invoice_distributions aid
342: WHERE aid.invoice_id = c_invoice_id
343: AND aid.invoice_line_number = c_line_number
344: AND line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TERV',
345: 'TRV', 'IPV', 'ERV')

Line 829: INSERT INTO ap_invoice_distributions_all(

825:
826: ----------------------------------------------------------------------------
827: l_debug_info := 'create distributions';
828: ----------------------------------------------------------------------------
829: INSERT INTO ap_invoice_distributions_all(
830: invoice_id,
831: invoice_line_number,
832: dist_code_combination_id,
833: invoice_distribution_id,

Line 969: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

965: (SELECT
966: P_Invoice_Id, -- invoice_id
967: l_Line_Number, -- invoice_line_number
968: Dist_Code_Combination_Id, -- dist_code_combination_id
969: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
970: sysdate, -- last_update_date
971: FND_GLOBAL.user_id, -- last_updated_by
972: P_Dm_Gl_Date, -- accounting_date
973: l_period_name, -- period_name

Line 1101: FROM ap_invoice_distributions_all

1097: asset_category_id, -- asset_category_id
1098: NULL, -- accounting_event_id -- bug 5152035
1099: 'N', -- cancellation_flag
1100: 'N' -- rcv_charge_addition_flag
1101: FROM ap_invoice_distributions_all
1102: WHERE invoice_id = P_Invoice_Lines_Tab(i).invoice_id
1103: AND invoice_line_number = P_Invoice_Lines_Tab(i).line_number
1104: AND line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TERV', 'TRV',
1105: 'IPV', 'ERV')

Line 1116: UPDATE ap_invoice_distributions_all aid

1112:
1113: ----------------------------------------------------------------------------
1114: l_debug_info := 'Update charge_applicable_to_dist_id for allocation info ...';
1115: ----------------------------------------------------------------------------
1116: UPDATE ap_invoice_distributions_all aid
1117: SET aid.charge_applicable_to_dist_id =
1118: (SELECT d1.invoice_distribution_id
1119: FROM ap_invoice_distributions_all d,
1120: ap_invoice_distributions_all cor,

Line 1119: FROM ap_invoice_distributions_all d,

1115: ----------------------------------------------------------------------------
1116: UPDATE ap_invoice_distributions_all aid
1117: SET aid.charge_applicable_to_dist_id =
1118: (SELECT d1.invoice_distribution_id
1119: FROM ap_invoice_distributions_all d,
1120: ap_invoice_distributions_all cor,
1121: ap_invoice_distributions_all d1
1122: WHERE d.invoice_id = aid.invoice_id
1123: AND d.invoice_distribution_id = aid.invoice_distribution_id

Line 1120: ap_invoice_distributions_all cor,

1116: UPDATE ap_invoice_distributions_all aid
1117: SET aid.charge_applicable_to_dist_id =
1118: (SELECT d1.invoice_distribution_id
1119: FROM ap_invoice_distributions_all d,
1120: ap_invoice_distributions_all cor,
1121: ap_invoice_distributions_all d1
1122: WHERE d.invoice_id = aid.invoice_id
1123: AND d.invoice_distribution_id = aid.invoice_distribution_id
1124: AND d.corrected_invoice_dist_id = cor.invoice_distribution_id

Line 1121: ap_invoice_distributions_all d1

1117: SET aid.charge_applicable_to_dist_id =
1118: (SELECT d1.invoice_distribution_id
1119: FROM ap_invoice_distributions_all d,
1120: ap_invoice_distributions_all cor,
1121: ap_invoice_distributions_all d1
1122: WHERE d.invoice_id = aid.invoice_id
1123: AND d.invoice_distribution_id = aid.invoice_distribution_id
1124: AND d.corrected_invoice_dist_id = cor.invoice_distribution_id
1125: AND cor.charge_applicable_to_dist_id IS NOT NULL

Line 1134: FROM ap_invoice_distributions aid

1130: l_debug_info := 'MRC Maintenance...';
1131: ----------------------------------------------------------------------------
1132: SELECT aid.invoice_distribution_id
1133: BULK COLLECT INTO l_key_value_list
1134: FROM ap_invoice_distributions aid
1135: WHERE aid.invoice_id = P_Invoice_Id
1136: AND aid.invoice_line_number = l_line_number;
1137:
1138: l_key_value_list.DELETE;