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.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_LINES

Line 65: l_document_type zx_lines_det_factors.event_class_code%type;

61: ------------------------------------------------*/
62: C_LINES_PER_COMMIT CONSTANT NUMBER := 1000;
63: I Number;
64: l_line_level_action varchar2(20);
65: l_document_type zx_lines_det_factors.event_class_code%type;
66: l_trx_line_context_changed BOOLEAN;
67: l_state_tax_cnt NUMBER;
68: l_county_tax_cnt NUMBER;
69: l_city_tax_cnt NUMBER;

Line 823: , ZX_LINES_DET_FACTORS zldf

819: BEGIN
820: SELECT count(*)
821: INTO l_cnt_of_options_gt
822: FROM ZX_TRX_PRE_PROC_OPTIONS_GT ztppo
823: , ZX_LINES_DET_FACTORS zldf
824: WHERE ztppo.application_id = zldf.application_id
825: AND ztppo.entity_code = zldf.entity_code
826: AND ztppo.event_class_code = zldf.event_class_code
827: AND ztppo.trx_id = zldf.trx_id;

Line 876: FROM zx_lines_det_factors where

872: SELECT
873: output_tax_classification_code,receivables_trx_type_id,internal_organization_id, ship_to_location_id,
874: bill_to_location_id into
875: l_tax_code, l_trx_type_id, l_org_id, l_ship_to_location_id, l_bill_to_location_id
876: FROM zx_lines_det_factors where
877: application_id = l_application_id
878: and entity_code = l_entity_code
879: and event_class_code = l_event_class_code
880: and trx_id = l_trx_id

Line 990: , ZX_LINES_DET_FACTORS zldf

986: BEGIN
987: select zldf.line_level_action,zldf.inclusive_tax_override_flag
988: into l_line_level_action, l_inclusive_tax_override_flag
989: FROM ZX_TRX_PRE_PROC_OPTIONS_GT ztppo
990: , ZX_LINES_DET_FACTORS zldf
991: WHERE ztppo.application_id = zldf.application_id
992: AND ztppo.entity_code = zldf.entity_code
993: AND ztppo.event_class_code = zldf.event_class_code
994: AND ztppo.trx_id = zldf.trx_id;

Line 1770: FROM ZX_LINES

1766: IF l_application_id IS NOT NULL THEN
1767: BEGIN
1768: SELECT Count(*)
1769: INTO l_ver_count
1770: FROM ZX_LINES
1771: WHERE APPLICATION_ID = l_application_id
1772: AND TRX_ID = pg_trx_id_tab(I)
1773: AND TRX_LINE_ID = pg_trx_line_id_tab(I)
1774: AND TAX_PROVIDER_ID IS NOT NULL;

Line 2686: FROM ZX_LINES_DET_FACTORS zd

2682: --bug#6831713
2683: BEGIN
2684: SELECT nvl(zd.partner_migrated_flag, 'N') -- Bug 5007293
2685: INTO pg_ugraded_inv_flag_tab(I)
2686: FROM ZX_LINES_DET_FACTORS zd
2687: WHERE zd.event_class_mapping_id = pg_adj_doc_doc_type_id_tab(i)
2688: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)
2689: AND zd.trx_line_id = pg_adj_doc_line_id_tab(i)
2690: AND zd.trx_level_type = pg_adj_doc_trx_lev_type_tab(i)

Line 2692: FROM ZX_LINES zl

2688: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)
2689: AND zd.trx_line_id = pg_adj_doc_line_id_tab(i)
2690: AND zd.trx_level_type = pg_adj_doc_trx_lev_type_tab(i)
2691: AND EXISTS (SELECT 'Y'
2692: FROM ZX_LINES zl
2693: WHERE zl.application_id = zd.application_id
2694: AND zl.entity_code = zd.entity_code
2695: AND zl.event_class_code = zd.event_class_code
2696: AND zd.trx_id = pg_adj_doc_trx_id_tab(i)

Line 3292: From zx_lines_det_factors

3288: IF l_situs = 'SHIP_TO' THEN
3289: /* Bug 5090593: Making use of the location ids passed thru view.
3290: select nvl(ship_to_location_id, bill_to_location_id)
3291: INTO p_location_id
3292: From zx_lines_det_factors
3293: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
3294: trx_id = pg_trx_id_tab(I) and
3295: trx_line_id = pg_trx_line_id_tab(I) and
3296: trx_level_type = pg_trx_level_type_tab(I);

Line 3304: From zx_lines_det_factors

3300: ELSIF l_situs = 'SHIP_FROM' THEN
3301: /* Bug 5090593: Making use of the location ids passed thru view.
3302: select nvl(ship_from_location_id, bill_from_location_id)
3303: INTO p_location_id
3304: From zx_lines_det_factors
3305: WHERE event_class_mapping_id = pg_doc_type_id_tab(I) and
3306: trx_id = pg_trx_id_tab(I) and
3307: trx_line_id = pg_trx_line_id_tab(I) and
3308: trx_level_type = pg_trx_level_type_tab(I);

Line 3929: p_transaction_id IN ZX_LINES.trx_id%type,

3925:
3926: END CREATE_TAX_LINE;
3927:
3928: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3929: p_transaction_id IN ZX_LINES.trx_id%type,
3930: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3931: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3932: p_regime_code IN ZX_LINES.tax_regime_code%type,
3933: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

Line 3930: p_transaction_line_id IN ZX_LINES.trx_line_id%type,

3926: END CREATE_TAX_LINE;
3927:
3928: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3929: p_transaction_id IN ZX_LINES.trx_id%type,
3930: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3931: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3932: p_regime_code IN ZX_LINES.tax_regime_code%type,
3933: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3934: x_return_status OUT NOCOPY VARCHAR2 ) is

Line 3931: p_trx_level_type IN ZX_LINES.trx_level_type%type,

3927:
3928: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3929: p_transaction_id IN ZX_LINES.trx_id%type,
3930: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3931: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3932: p_regime_code IN ZX_LINES.tax_regime_code%type,
3933: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3934: x_return_status OUT NOCOPY VARCHAR2 ) is
3935:

Line 3932: p_regime_code IN ZX_LINES.tax_regime_code%type,

3928: Procedure get_doc_and_ext_att_info(p_evnt_cls_mapping_id IN ZX_EVNT_CLS_MAPPINGS.event_class_mapping_id%type,
3929: p_transaction_id IN ZX_LINES.trx_id%type,
3930: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3931: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3932: p_regime_code IN ZX_LINES.tax_regime_code%type,
3933: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3934: x_return_status OUT NOCOPY VARCHAR2 ) is
3935:
3936: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;

Line 3933: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,

3929: p_transaction_id IN ZX_LINES.trx_id%type,
3930: p_transaction_line_id IN ZX_LINES.trx_line_id%type,
3931: p_trx_level_type IN ZX_LINES.trx_level_type%type,
3932: p_regime_code IN ZX_LINES.tax_regime_code%type,
3933: p_tax_provider_id IN ZX_LINES.tax_provider_id%type,
3934: x_return_status OUT NOCOPY VARCHAR2 ) is
3935:
3936: trx_line_dist_tbl ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl%type;
3937: event_class_rec ZX_API_PUB.event_class_rec_type;

Line 3995: FROM zx_lines_det_factors

3991: l_EVENT_CLASS_CODE,
3992: l_TRX_ID ,
3993: l_TRX_LINE_ID,
3994: l_TRX_LEVEL_TYPE
3995: FROM zx_lines_det_factors
3996: WHERE event_class_mapping_id = p_evnt_cls_mapping_id
3997: AND trx_id = p_transaction_id
3998: AND trx_line_id = p_transaction_line_id
3999: AND trx_level_type = p_trx_level_type;

Line 4006: g_string :='No data found in zx_lines_det_factors ';

4002: IF (g_level_exception >= g_current_runtime_level ) THEN
4003: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
4004: END IF;
4005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4006: g_string :='No data found in zx_lines_det_factors ';
4007: error_exception_handle(g_string);
4008: RETURN;
4009: END;
4010:

Line 4102: , p_tax IN zx_lines.tax%type

4098:
4099: End Check_in_cache;
4100:
4101: PROCEDURE POPULATE_SYNC_TAX_AMTS(p_sync_tax_cnt IN NUMBER
4102: , p_tax IN zx_lines.tax%type
4103: , x_output_sync_tax_lines IN OUT NOCOPY zx_tax_partner_pkg.output_sync_tax_lines_tbl_type
4104: , x_return_status OUT NOCOPY VARCHAR2) IS
4105:
4106: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SYNC_TAX_AMTS';

Line 4335: FROM zx_lines_det_factors where

4331:
4332: SELECT output_tax_classification_code , receivables_trx_type_id,
4333: internal_organization_id into
4334: l_tax_code, l_trx_type_id, l_org_id
4335: FROM zx_lines_det_factors where
4336: application_id = l_application_id
4337: and entity_code = l_entity_code
4338: and event_class_code = l_event_class_code
4339: and trx_id = SYNC_TAX_LINES.transaction_id(1)

Line 4659: FROM ZX_LINES_DET_FACTORS

4655: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4656: BEGIN
4657: SELECT count(*)
4658: INTO l_cnt_of_det_factors
4659: FROM ZX_LINES_DET_FACTORS
4660: WHERE event_class_mapping_id = x_transaction_rec.document_type_id
4661: AND trx_id = x_transaction_rec.transaction_id;
4662: EXCEPTION WHEN OTHERS THEN
4663: l_cnt_of_det_factors := 0;

Line 4732: FROM zx_lines_det_factors where

4728:
4729: SELECT output_tax_classification_code,receivables_trx_type_id,
4730: internal_organization_id into
4731: l_tax_code,l_trx_type_id, l_org_id
4732: FROM zx_lines_det_factors where
4733: application_id = l_application_id
4734: and entity_code = l_entity_code
4735: and event_class_code = l_event_class_code
4736: and trx_id = l_trx_id