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_ALL

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