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_DET_FACTORS

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