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.JL_ZZ_TAX_VALIDATE_PKG dependencies on ZX_TRANSACTION_LINES_GT

Line 145: FROM zx_transaction_lines_gt lines_gt

141: lines_gt.trx_line_id,
142: 'ZX_TRX_BIZ_FC_CODE_NOT_EXIST',
143: l_trx_biz_fc_code_not_exists,
144: lines_gt.trx_level_type
145: FROM zx_transaction_lines_gt lines_gt
146: WHERE lines_gt.trx_business_category is NOT NULL
147: AND NOT EXISTS
148: (SELECT 1
149: FROM

Line 188: zx_transaction_lines_gt lines_gt

184: 'ZX_PRODUCT_FC_CODE_NOT_EXIST',
185: l_prd_fc_code_not_exists,
186: lines_gt.trx_level_type
187: FROM
188: zx_transaction_lines_gt lines_gt
189: WHERE lines_gt.product_fisc_classification is NOT NULL
190: AND NOT EXISTS
191: (
192: SELECT 1

Line 236: l_line_level_action ZX_TRANSACTION_LINES_GT.line_level_action%type;

232:
233: l_organization_id hr_organization_units.organization_id%type;
234: l_tax_lines_count number;
235:
236: l_line_level_action ZX_TRANSACTION_LINES_GT.line_level_action%type;
237: l_source_trx_id ZX_TRANSACTION_LINES_GT.source_trx_id%type;
238:
239:
240: BEGIN

Line 237: l_source_trx_id ZX_TRANSACTION_LINES_GT.source_trx_id%type;

233: l_organization_id hr_organization_units.organization_id%type;
234: l_tax_lines_count number;
235:
236: l_line_level_action ZX_TRANSACTION_LINES_GT.line_level_action%type;
237: l_source_trx_id ZX_TRANSACTION_LINES_GT.source_trx_id%type;
238:
239:
240: BEGIN
241:

Line 474: FROM ZX_TRANSACTION_LINES_GT

470: -- Bug#5639478-
471:
472: SELECT line_level_action
473: INTO l_line_level_action
474: FROM ZX_TRANSACTION_LINES_GT
475: WHERE rownum = 1;
476:
477: IF l_line_level_action = 'COPY_AND_CREATE' THEN
478:

Line 479: UPDATE ZX_TRANSACTION_LINES_GT L

475: WHERE rownum = 1;
476:
477: IF l_line_level_action = 'COPY_AND_CREATE' THEN
478:
479: UPDATE ZX_TRANSACTION_LINES_GT L
480: SET (L.product_fisc_classification,
481: L.trx_business_category,
482: L.product_category,
483: L.output_tax_classification_code ) =

Line 501: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

497: ELSE
498: -- keep current logic
499:
500:
501: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
502: USING (SELECT
503: fc.classification_code product_fisc_class,
504: Lines.trx_id
505: FROM

Line 508: zx_transaction_lines_gt lines ,

504: Lines.trx_id
505: FROM
506: zx_fc_product_fiscal_v fc,
507: mtl_item_categories mic,
508: zx_transaction_lines_gt lines ,
509: zx_trx_headers_gt header
510: WHERE
511: ((fc.country_code = Header.default_taxation_country
512: AND fc.country_code in ('AR', 'BR', 'CO'))

Line 543: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

539: INSERT (LINE_AMT) VALUES(NULL);
540:
541:
542:
543: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
544: USING (SELECT
545: Event.tax_event_class_code ||g_delimiter||global_attribute2 trx_business_category,
546: Lines.trx_id
547: FROM

Line 548: ZX_TRANSACTION_LINES_GT Lines ,

544: USING (SELECT
545: Event.tax_event_class_code ||g_delimiter||global_attribute2 trx_business_category,
546: Lines.trx_id
547: FROM
548: ZX_TRANSACTION_LINES_GT Lines ,
549: mtl_system_items items,
550: ZX_EVNT_CLS_MAPPINGS event
551: WHERE organization_id = l_organization_id
552: AND inventory_item_id = lines.product_id

Line 569: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

565:
566: -- In case where the product type is 'MEMO', default the Transaction Business Category
567: -- and Product Category from ar_memo_lines.
568:
569: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
570: USING (SELECT
571: Event.tax_event_class_code ||g_delimiter||Memo.global_attribute2 trx_business_category,
572: Memo.tax_product_category product_category,
573: Lines.trx_id

Line 575: ZX_TRANSACTION_LINES_GT Lines ,

571: Event.tax_event_class_code ||g_delimiter||Memo.global_attribute2 trx_business_category,
572: Memo.tax_product_category product_category,
573: Lines.trx_id
574: FROM
575: ZX_TRANSACTION_LINES_GT Lines ,
576: ar_memo_lines_all_b Memo,
577: ZX_EVNT_CLS_MAPPINGS event
578: WHERE Memo.memo_line_id = lines.product_id
579: AND lines.product_org_id is NULL

Line 617: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

613:
614: -- bug#5696143- populate output_tax_classification_code
615:
616:
617: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
618: USING (SELECT CTT.global_attribute4 output_tax_classification_code,
619: H.trx_id
620: FROM ZX_TRX_HEADERS_GT H,
621: RA_CUST_TRX_TYPES_ALL CTT,

Line 1948: ZX_TRANSACTION_LINES_GT lines_gt,

1944: ZX_TAXES_B tax ,
1945: ZX_STATUS_B status ,
1946: AR_VAT_TAX_ALL_B rate ,
1947: -- zx_import_tax_lines_gt temp_gt,
1948: ZX_TRANSACTION_LINES_GT lines_gt,
1949: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1950: GL_SETS_OF_BOOKS gsob
1951: WHERE
1952: lines_gt.trx_id = header.trx_id

Line 2220: zx_transaction_lines_gt lines_gt,

2216: END IMP_TAX_MISSING_IN_ADJUSTED_TO
2217: /* end bug 3676878 */
2218: FROM
2219: zx_trx_headers_gt header,
2220: zx_transaction_lines_gt lines_gt,
2221: zx_import_tax_lines_gt imptaxes_gt
2222: WHERE
2223: imptaxes_gt.application_id = header.application_id
2224: AND imptaxes_gt.entity_code = header.entity_code