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.

VIEW: APPS.GMF_XLA_SUBINV_V

Source

View Text - Preformatted


SELECT organization_id organization_id, organization_id subinv_organization_id, secondary_inventory_name subinventory_code, decode(asset_inventory, 1,'Y', 'N' ) subinv_asset_flag, subinventory_type subinventory_type, locator_type subinv_locator_type, expense_account subinv_expense_account, material_account subinv_material_account, material_overhead_account subinv_material_ovh_account, resource_account subinv_resource_account, overhead_account subinv_overhead_account, outside_processing_account subinv_osp_account, encumbrance_account subinv_encumbrance_account FROM mtl_secondary_inventories subinv

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_ID SUBINV_ORGANIZATION_ID
, SECONDARY_INVENTORY_NAME SUBINVENTORY_CODE
, DECODE(ASSET_INVENTORY
, 1
, 'Y'
, 'N' ) SUBINV_ASSET_FLAG
, SUBINVENTORY_TYPE SUBINVENTORY_TYPE
, LOCATOR_TYPE SUBINV_LOCATOR_TYPE
, EXPENSE_ACCOUNT SUBINV_EXPENSE_ACCOUNT
, MATERIAL_ACCOUNT SUBINV_MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT SUBINV_MATERIAL_OVH_ACCOUNT
, RESOURCE_ACCOUNT SUBINV_RESOURCE_ACCOUNT
, OVERHEAD_ACCOUNT SUBINV_OVERHEAD_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT SUBINV_OSP_ACCOUNT
, ENCUMBRANCE_ACCOUNT SUBINV_ENCUMBRANCE_ACCOUNT
FROM MTL_SECONDARY_INVENTORIES SUBINV