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 250: FROM zx_transaction_lines_gt lines_gt

246: 'ZX_TRX_BIZ_FC_CODE_NOT_EXIST',
247: l_trx_biz_fc_code_not_exists||'('||lines_gt.trx_business_category||')',
248: lines_gt.trx_level_type,
249: lines_gt.interface_line_id
250: FROM zx_transaction_lines_gt lines_gt
251: WHERE lines_gt.trx_business_category is NOT NULL
252: AND NOT EXISTS
253: (SELECT 1
254: FROM

Line 300: zx_transaction_lines_gt lines_gt

296: l_prd_fc_code_not_exists||'('||lines_gt.product_fisc_classification||')',
297: lines_gt.trx_level_type,
298: lines_gt.interface_line_id
299: FROM
300: zx_transaction_lines_gt lines_gt
301: WHERE lines_gt.product_fisc_classification is NOT NULL
302: AND NOT EXISTS
303: (
304: SELECT 1

Line 355: zx_transaction_lines_gt lines_gt

351: l_prd_category_not_exists||'('||lines_gt.product_category||')',
352: lines_gt.trx_level_type,
353: lines_gt.interface_line_id
354: FROM
355: zx_transaction_lines_gt lines_gt
356: WHERE lines_gt.product_category IS NOT NULL
357: AND NOT EXISTS
358: (
359: SELECT 1

Line 410: l_line_level_action ZX_TRANSACTION_LINES_GT.line_level_action%type;

406:
407:
408: PROCEDURE default_tax_attr (x_return_status OUT NOCOPY VARCHAR2) IS
409:
410: l_line_level_action ZX_TRANSACTION_LINES_GT.line_level_action%type;
411: l_source_trx_id ZX_TRANSACTION_LINES_GT.source_trx_id%type;
412:
413:
414: BEGIN

Line 411: l_source_trx_id ZX_TRANSACTION_LINES_GT.source_trx_id%type;

407:
408: PROCEDURE default_tax_attr (x_return_status OUT NOCOPY VARCHAR2) IS
409:
410: l_line_level_action ZX_TRANSACTION_LINES_GT.line_level_action%type;
411: l_source_trx_id ZX_TRANSACTION_LINES_GT.source_trx_id%type;
412:
413:
414: BEGIN
415:

Line 623: ZX_TRANSACTION_LINES_GT Lines

619: TaxLines.summary_tax_line_number
620: FROM
621: ZX_IMPORT_TAX_LINES_GT TaxLines,
622: ZX_TRX_HEADERS_GT Header,
623: ZX_TRANSACTION_LINES_GT Lines
624: WHERE
625: Taxlines.tax_line_allocation_flag = 'N' AND
626: TaxLines.tax_amt IS NULL AND
627: TaxLines.tax_rate IS NOT NULL AND

Line 673: FROM ZX_TRANSACTION_LINES_GT

669: -- Bug#5639478-
670:
671: SELECT line_level_action
672: INTO l_line_level_action
673: FROM ZX_TRANSACTION_LINES_GT
674: WHERE rownum = 1;
675:
676: IF l_line_level_action = 'COPY_AND_CREATE' THEN
677:

Line 678: UPDATE ZX_TRANSACTION_LINES_GT L

674: WHERE rownum = 1;
675:
676: IF l_line_level_action = 'COPY_AND_CREATE' THEN
677:
678: UPDATE ZX_TRANSACTION_LINES_GT L
679: SET (L.product_fisc_classification,
680: L.trx_business_category,
681: L.product_category,
682: L.output_tax_classification_code ) =

Line 700: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

696: ELSE
697: -- keep current logic
698:
699:
700: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
701: USING (SELECT
702: fc.classification_code product_fisc_class,
703: Lines.trx_id,
704: Lines.trx_line_id,

Line 709: zx_transaction_lines_gt lines ,

705: Lines.trx_level_type
706: FROM
707: zx_fc_product_fiscal_v fc,
708: mtl_item_categories mic,
709: zx_transaction_lines_gt lines ,
710: zx_trx_headers_gt header
711: WHERE
712: ((fc.country_code = Header.default_taxation_country
713: AND fc.country_code in ('AR', 'BR', 'CO'))

Line 746: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

742: INSERT (LINE_AMT) VALUES(NULL);
743:
744:
745:
746: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
747: USING (SELECT
748: Event.tax_event_class_code,
749: items.global_attribute2 trx_business_category,
750: Lines.trx_id,

Line 754: ZX_TRANSACTION_LINES_GT Lines ,

750: Lines.trx_id,
751: Lines.trx_line_id,
752: Lines.trx_level_type
753: FROM
754: ZX_TRANSACTION_LINES_GT Lines ,
755: mtl_system_items items,
756: ZX_EVNT_CLS_MAPPINGS event
757: WHERE items.organization_id = lines.Product_org_id
758: AND items.inventory_item_id = lines.product_id

Line 778: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

774:
775: -- In case where the product type is 'MEMO', default the Transaction Business Category
776: -- and Product Category from ar_memo_lines.
777:
778: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
779: USING (SELECT
780: Event.tax_event_class_code,
781: Memo.global_attribute2 trx_business_category,
782: Memo.tax_product_category product_category,

Line 787: ZX_TRANSACTION_LINES_GT Lines ,

783: Lines.trx_id,
784: Lines.trx_line_id,
785: Lines.trx_level_type
786: FROM
787: ZX_TRANSACTION_LINES_GT Lines ,
788: ar_memo_lines Memo,
789: ZX_EVNT_CLS_MAPPINGS event
790: WHERE Memo.memo_line_id = lines.product_id
791: AND lines.product_org_id is NULL

Line 812: MERGE INTO ZX_TRANSACTION_LINES_GT Lines

808:
809:
810: -- bug#5696143- populate output_tax_classification_code
811:
812: MERGE INTO ZX_TRANSACTION_LINES_GT Lines
813: USING (SELECT CTT.global_attribute4 output_tax_classification_code,
814: H.trx_id
815: FROM ZX_TRX_HEADERS_GT H,
816: RA_CUST_TRX_TYPES CTT,

Line 1785: ZX_TRANSACTION_LINES_GT lines_gt,

1781:
1782: FROM
1783: ZX_TRX_HEADERS_GT header,
1784: ZX_EVNT_CLS_MAPPINGS evntmap,
1785: ZX_TRANSACTION_LINES_GT lines_gt,
1786: GL_SETS_OF_BOOKS gsob
1787:
1788: WHERE
1789: lines_gt.trx_id = header.trx_id

Line 2149: ZX_TRANSACTION_LINES_GT lines_gt,

2145: ZX_TRX_HEADERS_GT header,
2146: ZX_REGIMES_B regime,
2147: ZX_TAXES_B tax,
2148: ZX_STATUS_B status,
2149: ZX_TRANSACTION_LINES_GT lines_gt,
2150: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2151: ZX_SUBSCRIPTION_DETAILS sd_reg,
2152: ZX_SUBSCRIPTION_DETAILS sd_tax,
2153: ZX_SUBSCRIPTION_DETAILS sd_status

Line 2451: ZX_TRANSACTION_LINES_GT lines_gt,

2447: 'N') TAX_RATE_PERCENTAGE_INVALID
2448: FROM ZX_TRX_HEADERS_GT header,
2449: ZX_RATES_B rate ,
2450: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2451: ZX_TRANSACTION_LINES_GT lines_gt,
2452: ZX_SUBSCRIPTION_DETAILS sd_rates
2453: WHERE taxlines_gt.trx_id = header.trx_id
2454: AND taxlines_gt.application_id = Header.application_id
2455: AND taxlines_gt.entity_code = Header.entity_code

Line 2659: zx_transaction_lines_gt lines_gt,

2655: END IMP_TAX_MISSING_IN_ADJUSTED_TO
2656: /* end bug 3676878 */
2657: FROM
2658: zx_trx_headers_gt header,
2659: zx_transaction_lines_gt lines_gt,
2660: zx_import_tax_lines_gt taxlines_gt
2661: WHERE
2662: taxlines_gt.application_id = header.application_id
2663: AND taxlines_gt.entity_code = header.entity_code