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 MTL_SYSTEM_ITEMS

Line 657: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.

653: /* Defaulting for Transaction Business Category, Product Category and
654: Product Fiscal Classification on transaction lines */
655:
656: -- In case where the line is not a memo line, default the Transaction Business
657: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
658: -- If the line is a memo line, then populate Transaction Business Category and
659: -- Product Category from ar_memo_lines.
660:
661: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 755: mtl_system_items items,

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
759: AND lines.product_org_id is not NULL

Line 903: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.

899: /* Defaulting for Transaction Business Category, Product Category and
900: Product Fiscal Classification on transaction lines */
901:
902: -- In case where the line is not a memo line, default the Transaction Business
903: -- Category and Product Fiscal Classification from mtl_system_items / mtl_item_categories.
904: -- If the line is a memo line, then populate Transaction Business Category and
905: -- Product Category from ar_memo_lines.
906:
907: l_organization_id := zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index);

Line 921: -- from mtl_system_items.

917: IF zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index) IS NOT NULL
918: AND zx_global_structures_pkg.trx_line_dist_tbl.product_org_id(p_trx_line_index) is NOT NULL THEN
919:
920: -- It is an inveontory item; Populate product_fisc_classification and trx_business_category
921: -- from mtl_system_items.
922: If zx_global_structures_pkg.trx_line_dist_tbl.trx_business_category(p_trx_line_index) is NULL then
923:
924: IF g_delimiter is NULL then
925: OPEN c_delimiter;

Line 946: mtl_system_items items

942: ||g_delimiter||items.global_attribute2) trx_business_category
943: INTO
944: l_trx_business_category
945: FROM
946: mtl_system_items items
947: WHERE organization_id = l_organization_id
948: AND inventory_item_id = zx_global_structures_pkg.trx_line_dist_tbl.product_id(p_trx_line_index);
949:
950: