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_TRX_HEADERS_GT

Line 48: trx_date zx_trx_headers_gt.trx_date%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,
52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,

Line 49: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%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,
52: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
53: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,

Line 50: precision zx_trx_headers_gt.precision%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,
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,

Line 57: related_doc_date zx_trx_headers_gt.related_doc_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,
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

Line 58: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_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,
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: );

Line 1828: INDEX(headergt ZX_TRX_HEADERS_GT_U1)

1824: x_return_status OUT NOCOPY VARCHAR2) IS
1825:
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,

Line 1863: FROM zx_trx_headers_gt headergt,

1859: headergt.provnl_tax_determination_date,
1860: linegt.tax_date ,
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

Line 6407: | populating eBTax Global Temporary tables zx_trx_headers_gt and |

6403: | ra_customer_Trx_lines into named columns trx_busoness_category, |
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 |

Line 6431: -- zx_evnt_cls_mappings, not from zx_trx_headers_gt

6427: FETCH c_delimiter INTO l_delimiter;
6428: CLOSE c_delimiter;
6429:
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

Line 6444: --zx_trx_headers_gt Headers,

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
6448: lines.application_id = 222

Line 6480: --zx_trx_headers_gt Headers,

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
6484: lines.application_id = 222