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 322: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID,

318: null rounding_amt, --will be populated by the corr API
319: aid.unit_price unit_price,
320: null pa_quantity,
321: AID.DIST_CODE_COMBINATION_ID DIST_CCID
322: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID,
323: AP_INVOICE_DISTRIBUTIONS_ALL AID_IPV --added for bug13431447
324: WHERE AID.INVOICE_ID = C_INVOICE_ID
325: AND AID.INVOICE_LINE_NUMBER = C_LINE_NUMBER
326: --bug13431447 starts

Line 323: AP_INVOICE_DISTRIBUTIONS_ALL AID_IPV --added for bug13431447

319: aid.unit_price unit_price,
320: null pa_quantity,
321: AID.DIST_CODE_COMBINATION_ID DIST_CCID
322: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID,
323: AP_INVOICE_DISTRIBUTIONS_ALL AID_IPV --added for bug13431447
324: WHERE AID.INVOICE_ID = C_INVOICE_ID
325: AND AID.INVOICE_LINE_NUMBER = C_LINE_NUMBER
326: --bug13431447 starts
327: AND AID.INVOICE_DISTRIBUTION_ID=AID_IPV.RELATED_ID(+)

Line 349: FROM AP_INVOICE_DISTRIBUTIONS AID,

345: null rounding_amt, --will be populated by the corr API
346: aid.unit_price unit_price,
347: null pa_quantity,
348: aid.dist_code_combination_id dist_ccid
349: FROM AP_INVOICE_DISTRIBUTIONS AID,
350: AP_INVOICE_DISTRIBUTIONS_ALL AID_IPV --added for bug13431447
351: WHERE aid.invoice_id = c_invoice_id
352: AND AID.INVOICE_LINE_NUMBER = C_LINE_NUMBER
353: --bug13431447 starts

Line 350: AP_INVOICE_DISTRIBUTIONS_ALL AID_IPV --added for bug13431447

346: aid.unit_price unit_price,
347: null pa_quantity,
348: aid.dist_code_combination_id dist_ccid
349: FROM AP_INVOICE_DISTRIBUTIONS AID,
350: AP_INVOICE_DISTRIBUTIONS_ALL AID_IPV --added for bug13431447
351: WHERE aid.invoice_id = c_invoice_id
352: AND AID.INVOICE_LINE_NUMBER = C_LINE_NUMBER
353: --bug13431447 starts
354: AND AID.INVOICE_DISTRIBUTION_ID=AID_IPV.RELATED_ID(+)

Line 851: INSERT INTO ap_invoice_distributions_all(

847:
848: ----------------------------------------------------------------------------
849: l_debug_info := 'create distributions';
850: ----------------------------------------------------------------------------
851: INSERT INTO ap_invoice_distributions_all(
852: invoice_id,
853: invoice_line_number,
854: dist_code_combination_id,
855: invoice_distribution_id,

Line 991: ap_invoice_distributions_s.NEXTVAL, -- distribution_id

987: (SELECT
988: P_Invoice_Id, -- invoice_id
989: l_Line_Number, -- invoice_line_number
990: Dist_Code_Combination_Id, -- dist_code_combination_id
991: ap_invoice_distributions_s.NEXTVAL, -- distribution_id
992: sysdate, -- last_update_date
993: FND_GLOBAL.user_id, -- last_updated_by
994: P_Dm_Gl_Date, -- accounting_date
995: l_period_name, -- period_name

Line 1130: FROM ap_invoice_distributions_all

1126: asset_category_id, -- asset_category_id
1127: NULL, -- accounting_event_id -- bug 5152035
1128: 'N', -- cancellation_flag
1129: 'N' -- rcv_charge_addition_flag
1130: FROM ap_invoice_distributions_all
1131: WHERE invoice_id = P_Invoice_Lines_Tab(i).invoice_id
1132: AND invoice_line_number = P_Invoice_Lines_Tab(i).line_number
1133: AND line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TERV', 'TRV',
1134: 'IPV', 'ERV')

Line 1145: UPDATE ap_invoice_distributions_all aid

1141:
1142: ----------------------------------------------------------------------------
1143: l_debug_info := 'Update charge_applicable_to_dist_id for allocation info ...';
1144: ----------------------------------------------------------------------------
1145: UPDATE ap_invoice_distributions_all aid
1146: SET aid.charge_applicable_to_dist_id =
1147: (SELECT d1.invoice_distribution_id
1148: FROM ap_invoice_distributions_all d,
1149: ap_invoice_distributions_all cor,

Line 1148: FROM ap_invoice_distributions_all d,

1144: ----------------------------------------------------------------------------
1145: UPDATE ap_invoice_distributions_all aid
1146: SET aid.charge_applicable_to_dist_id =
1147: (SELECT d1.invoice_distribution_id
1148: FROM ap_invoice_distributions_all d,
1149: ap_invoice_distributions_all cor,
1150: ap_invoice_distributions_all d1
1151: WHERE d.invoice_id = aid.invoice_id
1152: AND d.invoice_distribution_id = aid.invoice_distribution_id

Line 1149: ap_invoice_distributions_all cor,

1145: UPDATE ap_invoice_distributions_all aid
1146: SET aid.charge_applicable_to_dist_id =
1147: (SELECT d1.invoice_distribution_id
1148: FROM ap_invoice_distributions_all d,
1149: ap_invoice_distributions_all cor,
1150: ap_invoice_distributions_all d1
1151: WHERE d.invoice_id = aid.invoice_id
1152: AND d.invoice_distribution_id = aid.invoice_distribution_id
1153: AND d.corrected_invoice_dist_id = cor.invoice_distribution_id

Line 1150: ap_invoice_distributions_all d1

1146: SET aid.charge_applicable_to_dist_id =
1147: (SELECT d1.invoice_distribution_id
1148: FROM ap_invoice_distributions_all d,
1149: ap_invoice_distributions_all cor,
1150: ap_invoice_distributions_all d1
1151: WHERE d.invoice_id = aid.invoice_id
1152: AND d.invoice_distribution_id = aid.invoice_distribution_id
1153: AND d.corrected_invoice_dist_id = cor.invoice_distribution_id
1154: AND cor.charge_applicable_to_dist_id IS NOT NULL

Line 1163: FROM ap_invoice_distributions aid

1159: l_debug_info := 'MRC Maintenance...';
1160: ----------------------------------------------------------------------------
1161: SELECT aid.invoice_distribution_id
1162: BULK COLLECT INTO l_key_value_list
1163: FROM ap_invoice_distributions aid
1164: WHERE aid.invoice_id = P_Invoice_Id
1165: AND aid.invoice_line_number = l_line_number;
1166:
1167: l_key_value_list.DELETE;