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_AWT_TEMP_DISTRIBUTIONS_ALL

Line 96: FROM ap_awt_temp_distributions_all AATD,

92: , AI.org_id
93: , AATD.awt_related_id
94: , aatd.checkrun_id
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

Line 155: FROM ap_awt_temp_distributions_all AATD,

151: , TC.TAX_ID
152: , SUM(AATD.withholding_amount) AMOUNT
153: , SUM(AATD.base_withholding_amount) BASE_AMOUNT
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

Line 191: FROM ap_awt_temp_distributions_all AATD,

187: --bug 7930936
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

Line 282: FROM ap_awt_temp_distributions_all AATD,

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

Line 295: FROM ap_awt_temp_distributions_all AATD,

291: non prepay awt distributions */
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

Line 377: update ap_awt_temp_distributions_all

373: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
375: END IF;
376:
377: update ap_awt_temp_distributions_all
378: set withholding_amount = withholding_amount + l_pro_prepay_awt_amt,
379: base_withholding_amount = base_withholding_amount + l_pro_prepay_awt_base_amt
380: where invoice_id = rec_nonprepay_awt.invoice_id
381: and awt_related_id = rec_nonprepay_awt.awt_related_id

Line 406: update ap_awt_temp_distributions_all

402: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
403: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
404: END IF;
405:
406: update ap_awt_temp_distributions_all
407: set withholding_amount = withholding_amount + l_amt_diff,
408: base_withholding_amount = base_withholding_amount + l_base_amt_diff
409: where invoice_id = P_INVOICE_ID
410: and awt_related_id = l_awt_related_id

Line 993: DELETE ap_awt_temp_distributions_all

989: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
990: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
991: END IF;
992:
993: DELETE ap_awt_temp_distributions_all
994: WHERE invoice_id = p_invoice_id
995: AND (P_Payment_Num IS NULL OR payment_num = P_Payment_Num);
996:
997:

Line 3307: FROM ap_awt_temp_distributions_all AATD

3303: END IF;
3304:
3305: SELECT NVL(SUM(AATD.withholding_amount), 0)
3306: INTO l_withholding_amount
3307: FROM ap_awt_temp_distributions_all AATD
3308: WHERE AATD.checkrun_name = P_Checkrun_Name
3309: AND AATD.invoice_id = rec_ok_sel_invs.invoice_id
3310: AND AATD.payment_num = rec_ok_sel_invs.payment_num
3311: and aatd.checkrun_id = p_checkrun_id;

Line 3735: FROM ap_awt_temp_distributions_all AATD,

3731: , AATD.checkrun_name
3732: , AATD.tax_rate_id
3733: , TC.tax_id tax_code_id
3734: , aatd.checkrun_id
3735: FROM ap_awt_temp_distributions_all AATD,
3736: ap_invoices_all AI,
3737: ap_tax_codes_all TC
3738: WHERE AATD.invoice_id = InvId
3739: AND AATD.invoice_id = AI.invoice_id

Line 3774: FROM ap_awt_temp_distributions_all AATD,

3770: , AATD.gross_amount
3771: , TC.tax_id tax_code_id
3772: , aatd.checkrun_id
3773: , AATD.accounting_date
3774: FROM ap_awt_temp_distributions_all AATD,
3775: ap_invoices_all AI,
3776: ap_tax_codes_all TC
3777: WHERE AATD.invoice_id = InvId
3778: AND AATD.invoice_id = AI.invoice_id

Line 4052: FROM ap_awt_temp_distributions_all atd

4048: AND payment_num = p_payment_num
4049: and checkrun_id = p_checkrun_id
4050: and exists
4051: (SELECT 1
4052: FROM ap_awt_temp_distributions_all atd
4053: WHERE atd.invoice_id = si.invoice_id
4054: AND atd.payment_num = si.payment_num
4055: AND atd.checkrun_id = si.checkrun_id);
4056:

Line 4080: DELETE ap_awt_temp_distributions_all

4076: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4077: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
4078: END IF;
4079:
4080: DELETE ap_awt_temp_distributions_all
4081: WHERE invoice_id = p_invoice_id
4082: AND ( ( (checkrun_name = NVL(p_checkrun_name, checkrun_name))
4083: AND (payment_num = NVL(p_payment_num, payment_num))
4084: and (checkrun_id = nvl(p_checkrun_id,checkrun_id)))

Line 5698: from ap_awt_temp_distributions_all table and hanlde awt buckets that are effected by them

5694: END;
5695: END Ap_Undo_Withholding;
5696:
5697: /*bug13606808, Added the procedure Ap_Undo_Orphan_Distributions to delete the orphan AWT distributions
5698: from ap_awt_temp_distributions_all table and hanlde awt buckets that are effected by them
5699: */
5700: PROCEDURE Ap_Undo_Orphan_Distributions (
5701: P_Invoice_Id IN NUMBER,
5702: P_Vendor_Id IN NUMBER DEFAULT NULL,

Line 5724: from ap_awt_temp_distributions_all AATD,

5720: cursor c_orphan_awt_buckets_w (InvId IN NUMBER
5721: ,PaymNum IN NUMBER)
5722: is
5723: select ai.vendor_id, aatd.accounting_date, aatd.tax_name, aatd.withholding_amount
5724: from ap_awt_temp_distributions_all AATD,
5725: ap_invoices_all AI
5726: where aatd.invoice_id = InvId
5727: and AATD.invoice_id = AI.invoice_id
5728: AND ( PaymNum IS NULL

Line 5740: from ap_awt_temp_distributions_all AATD,

5736: cursor c_orphan_awt_buckets_g (InvId IN NUMBER
5737: ,PaymNum IN NUMBER)
5738: is
5739: select ai.vendor_id, aatd.accounting_date, aatd.tax_name, aatd.gross_amount
5740: from ap_awt_temp_distributions_all AATD,
5741: ap_invoices_all AI
5742: where aatd.invoice_id = InvId
5743: and AATD.invoice_id = AI.invoice_id
5744: AND ( PaymNum IS NULL

Line 5751: select min(aatdx.awt_related_id) from ap_awt_temp_distributions_all aatdx

5747: AND (P_Calling_Module = 'QUICKCHECK'
5748: OR (P_Calling_Module = 'AUTOSELECT' and AATD.checkrun_id <> P_checkrun_id))
5749: and aatd.awt_related_id =
5750: (
5751: select min(aatdx.awt_related_id) from ap_awt_temp_distributions_all aatdx
5752: where aatdx.invoice_id = InvId
5753: and aatdx.checkrun_name = aatd.checkrun_name
5754: and aatdx.payment_num = aatd.payment_num
5755: and aatdx.checkrun_id = aatd.checkrun_id

Line 5919: FROM ap_awt_temp_distributions_all AATD

5915: END IF;
5916: END;
5917:
5918: DELETE
5919: FROM ap_awt_temp_distributions_all AATD
5920: where aatd.invoice_id = P_Invoice_Id
5921: AND (P_Payment_Num IS NULL
5922: OR AATD.payment_num = P_Payment_Num)
5923: AND P_Calling_Module <> 'AUTOAPPROVAL'