APPS.AP_QUICK_CREDIT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

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 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 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