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_ETAX_UTILITY_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 28: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all

24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_ETAX_UTILITY_PKG.';
27:
28: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
29:
30: TYPE r_ins_tax_dist_info IS RECORD (
31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

Line 2300: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all

2296: l_frozen_tax_dist_id NUMBER;
2297: l_frozen_summary_tax_line_id NUMBER;
2298: --Bug9021265
2299:
2300: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
2301:
2302: TYPE r_upd_tax_dist_info IS RECORD (
2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

Line 2432: FROM ap_self_assessed_tax_dist_all aid,

2428: cursor frozen_self_dist_del IS
2429: SELECT /*+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) */ -- 9485828
2430: detail_tax_dist_id, aid.summary_tax_line_id , invoice_id
2431:
2432: FROM ap_self_assessed_tax_dist_all aid,
2433: zx_trx_headers_gt gt
2434: WHERE aid.line_type_lookup_code IN ('NONREC_TAX','REC_TAX')
2435: AND (aid.accounting_event_id IS NOT NULL OR
2436: NVL(aid.match_status_flag,'N') IN ('A','T') OR

Line 3812: FROM ap_self_assessed_tax_dist_all aid

3808: AND zd.trx_id = parent_taxable_dist.invoice_id(+)
3809: AND zd.trx_line_dist_id = parent_taxable_dist.invoice_distribution_id(+)
3810: AND NOT EXISTS
3811: (SELECT aid.detail_tax_dist_id
3812: FROM ap_self_assessed_tax_dist_all aid
3813: WHERE aid.invoice_id = ai.invoice_id
3814: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
3815: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
3816: -- Bug 7462582

Line 3985: ap_self_assessed_tax_dist_all aid,

3981: FROM zx_trx_headers_gt gt,
3982: zx_rec_nrec_dist zd,
3983: zx_lines zl,
3984: ap_invoices_all ai,
3985: ap_self_assessed_tax_dist_all aid,
3986: ap_supplier_sites_all pvs,
3987: ap_system_parameters_all asp,
3988: financials_system_params_all fsp,
3989: po_distributions_all pd,

Line 4433: UPDATE ap_self_assessed_tax_dist_all

4429: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4430: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4431: END IF;
4432:
4433: UPDATE ap_self_assessed_tax_dist_all
4434: SET accounting_date = l_inv_self_upd(j).accounting_date,
4435: last_updated_by = l_user_id,
4436: last_update_date = sysdate, /*Bug10101457: replaced l_sysdate with sysdate*/
4437: line_type_lookup_code = l_inv_self_upd(j).line_type_lookup_code,

Line 5263: FROM ap_self_assessed_tax_dist_all

5259: END IF;
5260:
5261: SELECT dist_code_combination_id
5262: INTO l_dist_code_combination_id
5263: FROM ap_self_assessed_tax_dist_all
5264: WHERE detail_tax_dist_id = l_inv_self_ins(i).reversed_tax_dist_id
5265: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TIPV','TRV','TERV')--Bug8834205
5266: AND rownum =1;
5267:

Line 5279: FROM ap_self_assessed_tax_dist_all

5275: END IF;
5276:
5277: SELECT dist_code_combination_id
5278: INTO l_dist_code_combination_id
5279: FROM ap_self_assessed_tax_dist_all
5280: WHERE detail_tax_dist_id = l_inv_self_ins(i).adjusted_doc_tax_dist_id
5281: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TIPV','TRV','TERV')--Bug8834205
5282: AND rownum =1;
5283:

Line 5373: INSERT INTO ap_self_assessed_tax_dist_all (

5369: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5370: END IF;
5371:
5372: BEGIN
5373: INSERT INTO ap_self_assessed_tax_dist_all (
5374: accounting_date,
5375: accrual_posted_flag,
5376: assets_addition_flag,
5377: assets_tracking_flag,

Line 5908: DELETE FROM ap_self_assessed_tax_dist_all aid

5904: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5905: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5906: END IF;
5907:
5908: DELETE FROM ap_self_assessed_tax_dist_all aid
5909: WHERE aid.invoice_distribution_id IN
5910: (SELECT /*+ leading(gt) cardinality(gt,1) */
5911: dist.invoice_distribution_id
5912: FROM zx_trx_headers_gt gt,

Line 5913: ap_self_assessed_tax_dist_all dist

5909: WHERE aid.invoice_distribution_id IN
5910: (SELECT /*+ leading(gt) cardinality(gt,1) */
5911: dist.invoice_distribution_id
5912: FROM zx_trx_headers_gt gt,
5913: ap_self_assessed_tax_dist_all dist
5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5917: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 6779: FROM AP_SELF_ASSESSED_TAX_DIST_ALL

6775: FROM ap_invoice_distributions_all
6776: WHERE detail_tax_dist_id = P_Tax_Dist_Id
6777: UNION /*Bug 13102935:added self assessed tax table*/
6778: SELECT invoice_distribution_id
6779: FROM AP_SELF_ASSESSED_TAX_DIST_ALL
6780: WHERE detail_tax_dist_id = P_Tax_Dist_Id;
6781:
6782: BEGIN
6783:

Line 9878: FROM ap_self_assessed_tax_dist_all

9874: BEGIN
9875:
9876: SELECT nvl(max(distribution_line_number),0)
9877: INTO l_max_dist_line_num
9878: FROM ap_self_assessed_tax_dist_all
9879: WHERE invoice_id = X_invoice_id
9880: AND invoice_line_number = X_line_number;
9881:
9882: RETURN(l_max_dist_line_num);