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_PRODUCT_INTEGRATION_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 46: trx_line_id zx_transaction_lines_gt.trx_line_id%TYPE,

42: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
46: trx_line_id zx_transaction_lines_gt.trx_line_id%TYPE,
47: line_amt zx_transaction_lines_gt.line_amt%TYPE,
48: trx_date zx_trx_headers_gt.trx_date%TYPE,
49: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: precision zx_trx_headers_gt.precision%TYPE,

Line 47: line_amt zx_transaction_lines_gt.line_amt%TYPE,

43: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
44: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
45: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
46: trx_line_id zx_transaction_lines_gt.trx_line_id%TYPE,
47: line_amt zx_transaction_lines_gt.line_amt%TYPE,
48: trx_date zx_trx_headers_gt.trx_date%TYPE,
49: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: precision zx_trx_headers_gt.precision%TYPE,
51: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,

Line 51: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,

47: line_amt zx_transaction_lines_gt.line_amt%TYPE,
48: trx_date zx_trx_headers_gt.trx_date%TYPE,
49: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: precision zx_trx_headers_gt.precision%TYPE,
51: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
54: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,

Line 52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,

48: trx_date zx_trx_headers_gt.trx_date%TYPE,
49: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: precision zx_trx_headers_gt.precision%TYPE,
51: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
54: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,

Line 53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,

49: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,
50: precision zx_trx_headers_gt.precision%TYPE,
51: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
54: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
57: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,

Line 54: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,

50: precision zx_trx_headers_gt.precision%TYPE,
51: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
54: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
57: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
58: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,

Line 59: tax_date zx_transaction_lines_gt.tax_date%type,

55: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
57: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
58: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
59: tax_date zx_transaction_lines_gt.tax_date%type,
60: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
61: tax_point_date zx_transaction_lines_gt.tax_point_date%type
62: );
63:

Line 60: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,

56: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
57: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
58: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
59: tax_date zx_transaction_lines_gt.tax_date%type,
60: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
61: tax_point_date zx_transaction_lines_gt.tax_point_date%type
62: );
63:
64: -- Private Methods

Line 61: tax_point_date zx_transaction_lines_gt.tax_point_date%type

57: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
58: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
59: tax_date zx_transaction_lines_gt.tax_date%type,
60: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
61: tax_point_date zx_transaction_lines_gt.tax_point_date%type
62: );
63:
64: -- Private Methods
65: PROCEDURE get_vat_tax_rate;

Line 1830: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/

1826: CURSOR get_detail_tax_lines_csr IS
1827: SELECT /*+ ORDERED
1828: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
1829: INDEX(taxgt ZX_IMPORT_TAX_LINES_GT_U1)
1830: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/
1831: taxgt.summary_tax_line_number,
1832: taxgt.internal_organization_id,
1833: taxgt.tax_regime_code,
1834: taxgt.tax,

Line 1865: zx_transaction_lines_gt linegt

1861: linegt.tax_determine_date,
1862: linegt.tax_point_date
1863: FROM zx_trx_headers_gt headergt,
1864: zx_import_tax_lines_gt taxgt,
1865: zx_transaction_lines_gt linegt
1866: WHERE headergt.application_id = p_event_class_rec.application_id
1867: AND headergt.event_class_code = p_event_class_rec.event_class_code
1868: AND headergt.entity_code = p_event_class_rec.entity_code
1869: AND headergt.trx_id = p_event_class_rec.trx_id

Line 6408: | zx_transaction_lines_gt during autoinvoice |

6404: | product_category and product_fiscal_class for Latin Tax Engine |
6405: | |
6406: | This procedure should be called by Receivables at the time of |
6407: | populating eBTax Global Temporary tables zx_trx_headers_gt and |
6408: | zx_transaction_lines_gt during autoinvoice |
6409: | |
6410: | MODIFICATION HISTORY |
6411: | 19-Jan-2005 Nilesh Patel Created |
6412: | |

Line 6434: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt

6430: -- bug#6834705 - use tax_event_class_code from
6431: -- zx_evnt_cls_mappings, not from zx_trx_headers_gt
6432: --
6433:
6434: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt
6435: USING (SELECT
6436: ratrxlines.global_attribute_category,
6437: ratrxlines.global_attribute1,
6438: ratrxlines.global_attribute2 product_category,

Line 6443: zx_transaction_lines_gt Lines,

6439: ratrxlines.global_attribute3 trx_business_category,
6440: Event.tax_event_class_code tax_event_class_code,
6441: Lines.trx_line_id trx_line_id
6442: FROM
6443: zx_transaction_lines_gt Lines,
6444: --zx_trx_headers_gt Headers,
6445: zx_evnt_cls_mappings event,
6446: ra_customer_trx_lines_all ratrxlines
6447: WHERE

Line 6470: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt

6466: WHEN NOT MATCHED THEN
6467: INSERT (LINE_AMT) VALUES(NULL);
6468:
6469:
6470: MERGE INTO ZX_TRANSACTION_LINES_GT lines_gt
6471: USING (SELECT
6472: ratrxlines.global_attribute_category,
6473: ratrxlines.global_attribute1,
6474: ratrxlines.global_attribute2 product_fiscal_class,

Line 6479: zx_transaction_lines_gt Lines,

6475: ratrxlines.global_attribute3 trx_business_category,
6476: Event.tax_event_class_code tax_event_class_code,
6477: Lines.trx_line_id trx_line_id
6478: FROM
6479: zx_transaction_lines_gt Lines,
6480: --zx_trx_headers_gt Headers,
6481: zx_evnt_cls_mappings event,
6482: ra_customer_trx_lines_all ratrxlines
6483: WHERE