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_WITHHOLDING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 52: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

48: P_Check_Id IN NUMBER DEFAULT NULL) -- 8590059
49: IS
50: withholding_total NUMBER := 0;
51: base_withholding_total NUMBER := 0;
52: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
53:
54: --Bug 8266021 Changed Cursor to include two additional parameters GRP_ID and TAXID
55: --and included these two parameters in the where clause
56: CURSOR C_temp_dists (InvId IN NUMBER,GRP_ID IN NUMBER,TAXID IN NUMBER) IS

Line 99: ap_invoice_distributions_all AID --bug 7930936

95: , TC.description --Bug5502917
96: FROM ap_awt_temp_distributions_all AATD,
97: ap_invoices_all AI,
98: ap_tax_codes_all TC,
99: ap_invoice_distributions_all AID --bug 7930936
100: WHERE AATD.invoice_id = InvId
101: AND AATD.group_id = GRP_ID
102: AND AATD.invoice_id = AI.invoice_id
103: AND TC.TAX_ID = TAXID

Line 158: ap_invoice_distributions_all AID --bug 7930936

154: , MIN(AATD.accounting_date) ACCOUNTING_DATE
155: FROM ap_awt_temp_distributions_all AATD,
156: ap_invoices_all AI,
157: ap_tax_codes_all TC,
158: ap_invoice_distributions_all AID --bug 7930936
159: WHERE AATD.invoice_id = InvId
160: AND AATD.invoice_id = AI.invoice_id
161: AND AATD.tax_name = TC.name(+)
162: AND TC.org_id = AI.org_id -- Bug5902006

Line 185: curr_inv_dist_line_number ap_invoice_distributions_all.distribution_line_number%TYPE;

181: WHERE (invoice_id = InvId);
182:
183: curr_inv_line_number ap_invoice_lines_all.line_number%TYPE;
184: --bug 8266021
185: curr_inv_dist_line_number ap_invoice_distributions_all.distribution_line_number%TYPE;
186:
187: --bug 7930936
188: CURSOR C_NONPREPAY_AWT (InvId IN NUMBER)
189: IS

Line 192: ap_invoice_distributions_all AID

188: CURSOR C_NONPREPAY_AWT (InvId IN NUMBER)
189: IS
190: SELECT AATD.*
191: FROM ap_awt_temp_distributions_all AATD,
192: ap_invoice_distributions_all AID
193: WHERE AATD.invoice_id = InvId
194: AND AATD.invoice_id = AID.invoice_id
195: AND AATD.awt_related_id = AID.invoice_distribution_id
196: AND AID.prepay_distribution_id is NULL;

Line 226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;

222: l_disc_amt_factor NUMBER;
223: l_disc_amt_divisor NUMBER; -- BUG 7000143
224: l_basecur ap_system_parameters.base_currency_code%TYPE;
225: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
226: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
227: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
228: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
229: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;
230: l_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE;

Line 283: ap_invoice_distributions_all AID

279: --bug 7930936
280: SELECT nvl(sum(AATD.withholding_amount),0),nvl(sum(AATD.base_withholding_amount),0)
281: INTO l_prepay_awt_amount,l_prepay_awt_base_amount
282: FROM ap_awt_temp_distributions_all AATD,
283: ap_invoice_distributions_all AID
284: WHERE AATD.invoice_id = P_Invoice_Id
285: AND AATD.invoice_id = AID.invoice_id
286: AND AATD.awt_related_id = AID.invoice_distribution_id
287: AND AID.prepay_distribution_id is not NULL;

Line 296: ap_invoice_distributions_all AID

292:
293: SELECT sum(AATD.withholding_amount),sum(AATD.base_withholding_amount)
294: INTO l_non_prepay_awt_amount,l_non_prepay_awt_base_amount
295: FROM ap_awt_temp_distributions_all AATD,
296: ap_invoice_distributions_all AID
297: WHERE AATD.invoice_id = P_Invoice_Id
298: AND AATD.invoice_id = AID.invoice_id
299: AND AATD.awt_related_id = AID.invoice_distribution_id
300: AND AID.prepay_distribution_id is NULL;

Line 710: debug_info := 'Insert INTO ap_invoice_distributions';

706: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
707: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
708: END IF;
709:
710: debug_info := 'Insert INTO ap_invoice_distributions';
711: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
713: END IF;
714:

Line 715: INSERT INTO ap_invoice_distributions_all (

711: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
713: END IF;
714:
715: INSERT INTO ap_invoice_distributions_all (
716: accounting_date
717: ,accrual_posted_flag
718: ,assets_addition_flag
719: ,assets_tracking_flag

Line 834: ,ap_invoice_distributions_s.nextval

830: rec_temp_dists.gross_amount/nvl(l_exchange_rate,1), --bug 8590059
831: P_currency_code)
832: ,rec_temp_dists.group_id
833: ,rec_temp_dists.invoice_payment_id
834: ,ap_invoice_distributions_s.nextval
835: ,rec_temp_dists.GLOBAL_ATTRIBUTE_CATEGORY
836: ,rec_temp_dists.GLOBAL_ATTRIBUTE1
837: ,rec_temp_dists.GLOBAL_ATTRIBUTE2
838: ,rec_temp_dists.GLOBAL_ATTRIBUTE3

Line 890: ( p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

886:
887:
888: --Bug 4539462 DBI logging
889: AP_DBI_PKG.Maintain_DBI_Summary
890: ( p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
891: p_operation => 'I',
892: p_key_value1 => P_invoice_id,
893: p_key_value2 => l_Invoice_distribution_id,
894: p_calling_sequence => current_calling_sequence);

Line 951: FROM ap_invoice_distributions_all aid

947: BEGIN
948:
949: SELECT max(aid.invoice_distribution_id)
950: INTO l_dist_id_to_round
951: FROM ap_invoice_distributions_all aid
952: WHERE aid.invoice_id = P_Invoice_Id
953: AND aid.line_type_lookup_code = 'AWT'
954: AND abs(aid.amount) =
955: (SELECT max(abs(aid1.amount))

Line 956: FROM ap_invoice_distributions_all aid1

952: WHERE aid.invoice_id = P_Invoice_Id
953: AND aid.line_type_lookup_code = 'AWT'
954: AND abs(aid.amount) =
955: (SELECT max(abs(aid1.amount))
956: FROM ap_invoice_distributions_all aid1
957: WHERE aid1.invoice_id = P_Invoice_Id
958: AND aid1.invoice_line_number = curr_inv_line_number
959: AND aid1.line_type_lookup_code = 'AWT');
960:

Line 971: UPDATE ap_invoice_distributions_all aid

967: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
968: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
969: END IF;
970:
971: UPDATE ap_invoice_distributions_all aid
972: SET aid.amount = aid.amount + l_round_amt,
973: aid.base_amount = aid.base_amount + l_round_base_amt
974: WHERE aid.invoice_id = P_Invoice_Id
975: AND aid.invoice_distribution_id = l_dist_id_to_round;

Line 1015: FROM AP_Invoice_Distributions_All AID_FRE,

1011: IF l_exclude_freight_from_disc = 'Y' THEN
1012:
1013: SELECT NVL(SUM(AID_AWT.Amount),0)
1014: INTO l_sub_withhold_amt
1015: FROM AP_Invoice_Distributions_All AID_FRE,
1016: AP_Invoice_Distributions_All AID_AWT
1017: WHERE AID_FRE.Invoice_ID = P_Invoice_Id
1018: AND AID_FRE.Invoice_ID = AID_AWT.Invoice_ID
1019: AND AID_FRE.Line_Type_Lookup_Code = 'FREIGHT'

Line 1016: AP_Invoice_Distributions_All AID_AWT

1012:
1013: SELECT NVL(SUM(AID_AWT.Amount),0)
1014: INTO l_sub_withhold_amt
1015: FROM AP_Invoice_Distributions_All AID_FRE,
1016: AP_Invoice_Distributions_All AID_AWT
1017: WHERE AID_FRE.Invoice_ID = P_Invoice_Id
1018: AND AID_FRE.Invoice_ID = AID_AWT.Invoice_ID
1019: AND AID_FRE.Line_Type_Lookup_Code = 'FREIGHT'
1020: AND AID_AWT.Line_Type_Lookup_code = 'AWT'

Line 1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

1308: ta_accts_pay_code_comb_id po_vendor_sites.accts_pay_code_combination_id%TYPE;
1309: ta_payment_currency_code po_vendor_sites.payment_currency_code%TYPE;
1310: c_payment_cross_rate ap_invoices.payment_cross_rate%TYPE;
1311: c_payment_cross_rate_type ap_invoices.payment_cross_rate_type%TYPE;
1312: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
1313: l_legal_entity_id ap_invoices_all.legal_entity_id%type;
1314:
1315: l_set_of_books_id ap_invoices_all.set_of_books_id%type;
1316: l_batch_id ap_invoices_all.batch_id%type;

Line 1321: l_dist_number ap_invoice_distributions_all.distribution_line_number%type;

1317: l_org_id ap_invoices_all.org_id%type;
1318: l_period_name gl_period_statuses.period_name%type;
1319:
1320: l_line_number ap_invoice_lines_all.line_number%type;
1321: l_dist_number ap_invoice_distributions_all.distribution_line_number%type;
1322:
1323:
1324:
1325: l_IBY_PAYMENT_METHOD varchar2(80);

Line 1376: FROM ap_invoice_distributions_all APID,

1372: --, APID.ussgl_transaction_code ussgl_transaction_code - Bug 4277744
1373: --, APID.ussgl_trx_code_context ussgl_trx_code_context - Bug 4277744
1374: , APID.org_id
1375: , APID.awt_related_id awt_related_id -- bug 9913164
1376: FROM ap_invoice_distributions_all APID,
1377: ap_invoice_distributions_all APID1,
1378: ap_tax_codes_all ATC,
1379: ap_invoices_all AI
1380: WHERE (APID.invoice_id = InvId)

Line 1377: ap_invoice_distributions_all APID1,

1373: --, APID.ussgl_trx_code_context ussgl_trx_code_context - Bug 4277744
1374: , APID.org_id
1375: , APID.awt_related_id awt_related_id -- bug 9913164
1376: FROM ap_invoice_distributions_all APID,
1377: ap_invoice_distributions_all APID1,
1378: ap_tax_codes_all ATC,
1379: ap_invoices_all AI
1380: WHERE (APID.invoice_id = InvId)
1381: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,line_num))

Line 1426: FROM ap_invoice_distributions_all APID,

1422: --, APID.ussgl_transaction_code ussgl_transaction_code - Bug 4277744
1423: --, APID.ussgl_trx_code_context ussgl_trx_code_context - Bug 4277744
1424: , APID.org_id
1425: , APID.awt_related_id awt_related_id -- bug 9913164
1426: FROM ap_invoice_distributions_all APID,
1427: ap_invoice_distributions_all APID1,
1428: ap_tax_codes_all ATC,
1429: ap_invoices_all AI
1430: WHERE (APID.invoice_id = InvId)

Line 1427: ap_invoice_distributions_all APID1,

1423: --, APID.ussgl_trx_code_context ussgl_trx_code_context - Bug 4277744
1424: , APID.org_id
1425: , APID.awt_related_id awt_related_id -- bug 9913164
1426: FROM ap_invoice_distributions_all APID,
1427: ap_invoice_distributions_all APID1,
1428: ap_tax_codes_all ATC,
1429: ap_invoices_all AI
1430: WHERE (APID.invoice_id = InvId)
1431: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,line_num))

Line 1468: FROM ap_invoice_distributions_all APID,

1464: SELECT min(APID.accounting_date) accounting_date
1465: , APID.withholding_tax_code_id tax_code_id
1466: , sum(-1 * NVL(APID.base_amount,APID.amount)) invoice_amount --bug 8597105
1467: , APID.invoice_line_number
1468: FROM ap_invoice_distributions_all APID,
1469: ap_invoice_distributions_all APID1,
1470: ap_tax_codes_all ATC,
1471: AP_INVOICES_ALL AI
1472: WHERE (APID.invoice_id = InvId)

Line 1469: ap_invoice_distributions_all APID1,

1465: , APID.withholding_tax_code_id tax_code_id
1466: , sum(-1 * NVL(APID.base_amount,APID.amount)) invoice_amount --bug 8597105
1467: , APID.invoice_line_number
1468: FROM ap_invoice_distributions_all APID,
1469: ap_invoice_distributions_all APID1,
1470: ap_tax_codes_all ATC,
1471: AP_INVOICES_ALL AI
1472: WHERE (APID.invoice_id = InvId)
1473: AND (APID.line_type_lookup_code = 'AWT')

Line 1505: FROM ap_invoice_distributions_all APID,

1501: SELECT min(APID.accounting_date) accounting_date
1502: , APID.withholding_tax_code_id tax_code_id
1503: , sum(-1 * NVL(APID.base_amount,APID.amount)) invoice_amount --bug 8597105
1504: , APID.invoice_line_number
1505: FROM ap_invoice_distributions_all APID,
1506: ap_invoice_distributions_all APID1,
1507: ap_tax_codes_all ATC,
1508: AP_INVOICES_ALL AI
1509: WHERE (APID.invoice_id = InvId)

Line 1506: ap_invoice_distributions_all APID1,

1502: , APID.withholding_tax_code_id tax_code_id
1503: , sum(-1 * NVL(APID.base_amount,APID.amount)) invoice_amount --bug 8597105
1504: , APID.invoice_line_number
1505: FROM ap_invoice_distributions_all APID,
1506: ap_invoice_distributions_all APID1,
1507: ap_tax_codes_all ATC,
1508: AP_INVOICES_ALL AI
1509: WHERE (APID.invoice_id = InvId)
1510: AND (APID.line_type_lookup_code = 'AWT')

Line 2078: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

2074:
2075: --To be resolved by DBI forward porting project.
2076: /*
2077: AP_DBI_PKG.Maintain_DBI_Summary
2078: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
2079: p_operation => 'I',
2080: p_key_value1 => new_invoice_id,
2081: p_key_value2 => l_Invoice_distribution_Id,
2082: p_calling_sequence => current_calling_sequence); */

Line 2146: debug_info := 'Insert INTO ap_invoice_distributions';

2142: END IF;
2143:
2144: l_dist_number := l_dist_number + 1 ;
2145:
2146: debug_info := 'Insert INTO ap_invoice_distributions';
2147: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2148: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2149: END IF;
2150:

Line 2155: FROM ap_invoice_distributions_all

2151: --bug 9913164 begins
2152: IF nvl(l_automatic_offsets,'N') = 'Y' THEN
2153: SELECT dist_code_combination_id
2154: INTO l_dist_code_ccid
2155: FROM ap_invoice_distributions_all
2156: WHERE invoice_distribution_id = rec_awt_lines.awt_related_id;
2157:
2158: AP_UTILITIES_PKG.g_org_id := rec_awt_lines.org_id; /*Bug11720134 : Setting the org id global parameter*/
2159:

Line 2186: SELECT ap_invoice_distributions_s.nextval

2182: END IF;
2183: END IF;
2184: --bug 9913164 end
2185:
2186: SELECT ap_invoice_distributions_s.nextval
2187: INTO l_invoice_distribution_id
2188: FROM DUAL;
2189:
2190:

Line 2191: INSERT INTO ap_invoice_distributions_all (

2187: INTO l_invoice_distribution_id
2188: FROM DUAL;
2189:
2190:
2191: INSERT INTO ap_invoice_distributions_all (
2192: accounting_date
2193: ,accrual_posted_flag
2194: ,assets_addition_flag
2195: ,assets_tracking_flag

Line 2329: ( p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

2325: ,'N'
2326: ,'PERMANENT'); -- bug 8304036: modify
2327:
2328: AP_DBI_PKG.Maintain_DBI_Summary
2329: ( p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
2330: p_operation => 'I',
2331: p_key_value1 => new_invoice_id,
2332: p_key_value2 => l_invoice_distribution_id,
2333: p_calling_sequence => current_calling_sequence);

Line 2336: debug_info := 'Update ap_invoice_distributions';

2332: p_key_value2 => l_invoice_distribution_id,
2333: p_calling_sequence => current_calling_sequence);
2334:
2335: --bug 8266021
2336: debug_info := 'Update ap_invoice_distributions';
2337: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2339: END IF;
2340:

Line 2342: UPDATE ap_invoice_distributions_all

2338: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2339: END IF;
2340:
2341: IF (P_Calling_Module in ('CANCEL INVOICE','REVERSE DIST','VOID PAYMENT')) THEN
2342: UPDATE ap_invoice_distributions_all
2343: SET awt_invoice_id = new_invoice_id
2344: WHERE current of c_awt_lines_rev;
2345: ELSE
2346: UPDATE ap_invoice_distributions_all

Line 2346: UPDATE ap_invoice_distributions_all

2342: UPDATE ap_invoice_distributions_all
2343: SET awt_invoice_id = new_invoice_id
2344: WHERE current of c_awt_lines_rev;
2345: ELSE
2346: UPDATE ap_invoice_distributions_all
2347: SET awt_invoice_id = new_invoice_id
2348: WHERE current of c_awt_lines;
2349:
2350: END IF;

Line 2404: debug_info := 'Update ap_invoice_distributions';

2400:
2401: -- End: Update original negative distribution with new invoice id:
2402:
2403: /* commented in bug 8266021 ,this update has been moved up
2404: debug_info := 'Update ap_invoice_distributions';
2405: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2406: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2407: END IF;
2408:

Line 2409: UPDATE ap_invoice_distributions_all

2405: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2406: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
2407: END IF;
2408:
2409: UPDATE ap_invoice_distributions_all
2410: SET awt_invoice_id = new_invoice_id
2411: WHERE current of c_awt_lines;
2412: */
2413:

Line 3051: FROM ap_invoice_distributions AID

3047: AND AI.invoice_id = ASI.invoice_id
3048: AND AI.org_id = asp.org_id
3049: AND NVL(ASI.ok_to_pay_flag,'Y') IN ( 'Y','F')
3050: AND NOT EXISTS (SELECT 'Manual AWT dists exist'
3051: FROM ap_invoice_distributions AID
3052: WHERE AID.invoice_id = ASI.invoice_id
3053: AND AID.line_type_lookup_code = 'AWT'
3054: AND AID.awt_flag = 'M')
3055: AND ((ASP.create_awt_dists_type ='PAYMENT' --Bug6660355

Line 3064: FROM ap_invoice_distributions AID

3060: OR
3061: ASP.create_awt_dists_type ='BOTH')
3062:
3063: AND EXISTS (SELECT 'At least one dist exists with AWT_GROUP_ID'
3064: FROM ap_invoice_distributions AID
3065: WHERE AID.invoice_id = ASI.invoice_id
3066: AND AID.pay_awt_group_id IS NOT NULL) --Bug8631142
3067: AND ASI.original_invoice_id IS NULL --Bug6660355
3068: AND decode(nvl(ASP.allow_awt_flag, 'N'), 'Y',

Line 3165: FROM ap_invoice_distributions

3161:
3162: /*Start of Bug 14530960*/
3163: SELECT sum(nvl(base_amount,amount))
3164: INTO l_invoice_amount
3165: FROM ap_invoice_distributions
3166: WHERE invoice_id = rec_ok_sel_invs.invoice_id
3167: AND line_type_lookup_code <> 'AWT'; /*End of Bug 14530960*/
3168:
3169: --Bug6660355

Line 3172: FROM ap_invoice_distributions aid,ap_invoices ai

3168:
3169: --Bug6660355
3170: /*SELECT sum(nvl(aid.base_amount,aid.amount)) --query is commented for Bug:14696775
3171: INTO l_total_awt_amount
3172: FROM ap_invoice_distributions aid,ap_invoices ai
3173: WHERE aid.invoice_id = ai.invoice_id
3174: AND aid.invoice_id =rec_ok_sel_invs.invoice_id
3175: AND aid.line_type_lookup_code in ('AWT')
3176: AND aid.awt_origin_group_id = ai.awt_group_id;*/

Line 3181: FROM ap_invoice_distributions aid

3177:
3178: --query is added for Bug:14696775
3179: SELECT sum(nvl(aid.base_amount,aid.amount))
3180: INTO l_total_awt_amount
3181: FROM ap_invoice_distributions aid
3182: WHERE aid.invoice_id =rec_ok_sel_invs.invoice_id
3183: AND aid.line_type_lookup_code in ('AWT')
3184: AND aid.awt_invoice_payment_id is null;
3185:

Line 4247: gl_period_name ap_invoice_distributions.period_name%TYPE;

4243:
4244: -- PL/SQL Main Block Constants AND Variables:
4245:
4246: awt_period ap_other_periods.period_name%TYPE;
4247: gl_period_name ap_invoice_distributions.period_name%TYPE;
4248: gl_awt_date DATE;
4249: DBG_Loc VARCHAR2(30) := 'Ap_Undo_Withholding';
4250: current_calling_sequence VARCHAR2(2000);
4251: debug_info VARCHAR2(100);

Line 4388: FROM ap_invoice_distributions AID,

4384: , AID.global_attribute18
4385: , AID.global_attribute19
4386: , AID.global_attribute20
4387: /* End of fix for bug#8462050*/
4388: FROM ap_invoice_distributions AID,
4389: ap_tax_codes TC
4390: --,ap_invoices AI --Bug8547506
4391: WHERE AID.invoice_id = ParentId
4392: AND TC.tax_id (+) = AID.withholding_tax_code_id /* Bug 5382525 */

Line 4529: FROM ap_invoice_distributions AID,

4525: , AID.global_attribute18
4526: , AID.global_attribute19
4527: , AID.global_attribute20
4528: /* End of fix for bug#8462050*/
4529: FROM ap_invoice_distributions AID,
4530: ap_tax_codes TC
4531: WHERE AID.awt_invoice_payment_id = ParentId
4532: AND TC.tax_id(+) = AID.withholding_tax_code_id /* 5382525 */
4533: AND AID.invoice_line_number = NVL(P_Inv_Line_No,

Line 4559: FROM ap_invoice_distributions AID,

4555: , AID.awt_invoice_payment_id
4556: , AID.awt_gross_amount
4557:
4558: /* End of fix for bug#8462050*/
4559: FROM ap_invoice_distributions AID,
4560: ap_tax_codes TC
4561: WHERE AID.awt_invoice_payment_id = ParentId
4562: AND TC.tax_id(+) = AID.withholding_tax_code_id /* 5382525 */
4563: AND NVL(AID.awt_flag, 'M') = 'A';

Line 4580: FROM ap_invoice_distributions AID,

4576: , AID.awt_tax_rate_id
4577: , AID.awt_invoice_payment_id
4578: , AID.awt_gross_amount
4579: /* End of fix for bug#8462050*/
4580: FROM ap_invoice_distributions AID,
4581: ap_tax_codes TC
4582: --,ap_invoices AI --Bug8547506
4583: WHERE AID.invoice_id = ParentId
4584: AND TC.tax_id (+) = AID.withholding_tax_code_id

Line 4996: FROM ap_invoice_distributions

4992:
4993: CURSOR c_curr_dist (InvId IN NUMBER,
4994: InvLineNum IN NUMBER) IS
4995: SELECT MAX(distribution_line_number)+1 curr_line_number
4996: FROM ap_invoice_distributions
4997: WHERE invoice_id = InvId
4998: AND invoice_line_number = InvLineNum;
4999:
5000: curr_line_number ap_invoice_distributions.distribution_line_number%TYPE;

Line 5000: curr_line_number ap_invoice_distributions.distribution_line_number%TYPE;

4996: FROM ap_invoice_distributions
4997: WHERE invoice_id = InvId
4998: AND invoice_line_number = InvLineNum;
4999:
5000: curr_line_number ap_invoice_distributions.distribution_line_number%TYPE;
5001: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5002:
5003: BEGIN
5004: debug_info := 'OPEN CURSOR c_curr_dist';

Line 5001: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

4997: WHERE invoice_id = InvId
4998: AND invoice_line_number = InvLineNum;
4999:
5000: curr_line_number ap_invoice_distributions.distribution_line_number%TYPE;
5001: l_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5002:
5003: BEGIN
5004: debug_info := 'OPEN CURSOR c_curr_dist';
5005: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5075: debug_info := 'Insert reverse AWT line INTO ap_invoice_distributions';

5071: -- From now there will be no difference between REVERSE DIST and CANCEL INVOICE
5072: -- except when REVERSE DIST IS passed match status flag of newly created
5073: -- awt lines will be N else it will be Y.
5074:
5075: debug_info := 'Insert reverse AWT line INTO ap_invoice_distributions';
5076: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5077: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
5078: END IF;
5079:

Line 5080: INSERT INTO ap_invoice_distributions

5076: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5077: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
5078: END IF;
5079:
5080: INSERT INTO ap_invoice_distributions
5081: (
5082: accounting_date
5083: ,accrual_posted_flag
5084: ,assets_addition_flag

Line 5204: ,ap_invoice_distributions_s.nextval

5200: ,'N'
5201: ,''
5202: ,'N'
5203: ,'N'
5204: ,ap_invoice_distributions_s.nextval
5205: ,'N'
5206: ,rec_awt_dists.invoice_distribution_id
5207: ,rec_awt_dists.type_1099
5208: ,rec_awt_dists.income_tax_region

Line 5241: ( p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

5237: );
5238:
5239: --Bug 4539462 DBI logging
5240: AP_DBI_PKG.Maintain_DBI_Summary
5241: ( p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
5242: p_operation => 'I',
5243: p_key_value1 => rec_awt_dists.invoice_id,
5244: p_key_value2 => l_Invoice_distribution_ID,
5245: p_calling_sequence => current_calling_sequence);

Line 5539: UPDATE ap_invoice_distributions

5535: END IF;
5536:
5537: */
5538:
5539: UPDATE ap_invoice_distributions
5540: SET reversal_flag='Y'
5541: WHERE invoice_distribution_id = rec_awt_dists.invoice_distribution_id
5542: OR parent_reversal_id=rec_awt_dists.invoice_distribution_id;
5543:

Line 5572: FROM ap_invoice_distributions_all

5568:
5569: /*Bug 10353952 begins*/
5570: SELECT count(*)
5571: INTO l_pay_awt_invs_count
5572: FROM ap_invoice_distributions_all
5573: WHERE invoice_id = DECODE(p_calling_module,'VOID PAYMENT',rec_awt_dists.invoice_id,
5574: P_Parent_Id)
5575: AND line_type_lookup_code = 'AWT'
5576: AND awt_flag = 'A'

Line 5626: UPDATE ap_invoice_distributions

5622:
5623: IF (P_Calling_Module IN ('CANCEL INVOICE','REVERSE DIST')) THEN
5624: CLOSE c_awt_dists_inv;
5625:
5626: UPDATE ap_invoice_distributions
5627: SET awt_withheld_amt = NULL
5628: WHERE invoice_id = P_parent_id
5629: AND NVL(awt_withheld_amt,0) <> 0;
5630: