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.INVFV_SUBINVENTORIES

Source

View Text - Preformatted


SELECT MSS.SECONDARY_INVENTORY_NAME, MSS.ORGANIZATION_ID, MSS.DESCRIPTION, MP1.ORGANIZATION_CODE, HOU1.NAME, MSS.DISABLE_DATE, '_LA:MSS.INVENTORY_ATP_CODE:MFG_LOOKUPS:MTL_ATP_CODE:MEANING', '_LA:MSS.RESERVABLE_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING', '_LA:MSS.LOCATOR_TYPE:MFG_LOOKUPS:MTL_LOCATION_CONTROL:MEANING', MSS.PICKING_ORDER, '_LA:MSS.QUANTITY_TRACKED:MFG_LOOKUPS:SYS_YES_NO:MEANING', '_LA:MSS.ASSET_INVENTORY:MFG_LOOKUPS:SYS_YES_NO:MEANING', '_LA:MSS.SOURCE_TYPE:MFG_LOOKUPS:MTL_SOURCE_TYPES:MEANING', '_LA:MSS.AVAILABILITY_TYPE:MFG_LOOKUPS:MTL_AVAILABILITY:MEANING', MSS.PREPROCESSING_LEAD_TIME, MSS.PROCESSING_LEAD_TIME, MSS.POSTPROCESSING_LEAD_TIME, MSS.MATERIAL_ACCOUNT, '_KF:SQLGL:GL#:GLC1', MSS.MATERIAL_OVERHEAD_ACCOUNT, '_KF:SQLGL:GL#:GLC2', MSS.RESOURCE_ACCOUNT, '_KF:SQLGL:GL#:GLC3', MSS.OVERHEAD_ACCOUNT, '_KF:SQLGL:GL#:GLC4', MSS.OUTSIDE_PROCESSING_ACCOUNT, '_KF:SQLGL:GL#:GLC5', MSS.EXPENSE_ACCOUNT, '_KF:SQLGL:GL#:GLC6', MSS.ENCUMBRANCE_ACCOUNT, '_KF:SQLGL:GL#:GLC7', DECODE(MSS.SOURCE_TYPE, 1, MSS.SOURCE_ORGANIZATION_ID, NULL), DECODE(MSS.SOURCE_TYPE, 1, MP2.ORGANIZATION_CODE, NULL), DECODE(MSS.SOURCE_TYPE, 1, HOU2.NAME, NULL), DECODE(MSS.SOURCE_TYPE, 1, MSS.SOURCE_SUBINVENTORY, NULL), MSS.CREATED_BY, MSS.CREATION_DATE, MSS.LAST_UPDATED_BY, MSS.LAST_UPDATE_DATE FROM MTL_PARAMETERS MP1, MTL_PARAMETERS MP2, HR_ALL_ORGANIZATION_UNITS HOU1, HR_ALL_ORGANIZATION_UNITS HOU2, GL_CODE_COMBINATIONS GLC1, GL_CODE_COMBINATIONS GLC2, GL_CODE_COMBINATIONS GLC3, GL_CODE_COMBINATIONS GLC4, GL_CODE_COMBINATIONS GLC5, GL_CODE_COMBINATIONS GLC6, GL_CODE_COMBINATIONS GLC7, MTL_SECONDARY_INVENTORIES MSS WHERE GLC1.CODE_COMBINATION_ID (+) = MSS.MATERIAL_ACCOUNT AND GLC2.CODE_COMBINATION_ID (+) = MSS.MATERIAL_OVERHEAD_ACCOUNT AND GLC3.CODE_COMBINATION_ID (+) = MSS.RESOURCE_ACCOUNT AND GLC4.CODE_COMBINATION_ID (+) = MSS.OVERHEAD_ACCOUNT AND GLC5.CODE_COMBINATION_ID (+) = MSS.OUTSIDE_PROCESSING_ACCOUNT AND GLC6.CODE_COMBINATION_ID (+) = MSS.EXPENSE_ACCOUNT AND GLC7.CODE_COMBINATION_ID (+) = MSS.ENCUMBRANCE_ACCOUNT AND MP1.ORGANIZATION_ID = MSS.ORGANIZATION_ID AND MP2.ORGANIZATION_ID (+) = MSS.SOURCE_ORGANIZATION_ID AND HOU1.ORGANIZATION_ID = MSS.ORGANIZATION_ID AND HOU2.ORGANIZATION_ID (+) = MSS.SOURCE_ORGANIZATION_ID AND '_SEC:MSS.ORGANIZATION_ID' IS NOT NULL AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) WITH READ ONLY

View Text - HTML Formatted

SELECT MSS.SECONDARY_INVENTORY_NAME
, MSS.ORGANIZATION_ID
, MSS.DESCRIPTION
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MSS.DISABLE_DATE
, '_LA:MSS.INVENTORY_ATP_CODE:MFG_LOOKUPS:MTL_ATP_CODE:MEANING'
, '_LA:MSS.RESERVABLE_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MSS.LOCATOR_TYPE:MFG_LOOKUPS:MTL_LOCATION_CONTROL:MEANING'
, MSS.PICKING_ORDER
, '_LA:MSS.QUANTITY_TRACKED:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MSS.ASSET_INVENTORY:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MSS.SOURCE_TYPE:MFG_LOOKUPS:MTL_SOURCE_TYPES:MEANING'
, '_LA:MSS.AVAILABILITY_TYPE:MFG_LOOKUPS:MTL_AVAILABILITY:MEANING'
, MSS.PREPROCESSING_LEAD_TIME
, MSS.PROCESSING_LEAD_TIME
, MSS.POSTPROCESSING_LEAD_TIME
, MSS.MATERIAL_ACCOUNT
, '_KF:SQLGL:GL#:GLC1'
, MSS.MATERIAL_OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GLC2'
, MSS.RESOURCE_ACCOUNT
, '_KF:SQLGL:GL#:GLC3'
, MSS.OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GLC4'
, MSS.OUTSIDE_PROCESSING_ACCOUNT
, '_KF:SQLGL:GL#:GLC5'
, MSS.EXPENSE_ACCOUNT
, '_KF:SQLGL:GL#:GLC6'
, MSS.ENCUMBRANCE_ACCOUNT
, '_KF:SQLGL:GL#:GLC7'
, DECODE(MSS.SOURCE_TYPE
, 1
, MSS.SOURCE_ORGANIZATION_ID
, NULL)
, DECODE(MSS.SOURCE_TYPE
, 1
, MP2.ORGANIZATION_CODE
, NULL)
, DECODE(MSS.SOURCE_TYPE
, 1
, HOU2.NAME
, NULL)
, DECODE(MSS.SOURCE_TYPE
, 1
, MSS.SOURCE_SUBINVENTORY
, NULL)
, MSS.CREATED_BY
, MSS.CREATION_DATE
, MSS.LAST_UPDATED_BY
, MSS.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, GL_CODE_COMBINATIONS GLC1
, GL_CODE_COMBINATIONS GLC2
, GL_CODE_COMBINATIONS GLC3
, GL_CODE_COMBINATIONS GLC4
, GL_CODE_COMBINATIONS GLC5
, GL_CODE_COMBINATIONS GLC6
, GL_CODE_COMBINATIONS GLC7
, MTL_SECONDARY_INVENTORIES MSS
WHERE GLC1.CODE_COMBINATION_ID (+) = MSS.MATERIAL_ACCOUNT
AND GLC2.CODE_COMBINATION_ID (+) = MSS.MATERIAL_OVERHEAD_ACCOUNT
AND GLC3.CODE_COMBINATION_ID (+) = MSS.RESOURCE_ACCOUNT
AND GLC4.CODE_COMBINATION_ID (+) = MSS.OVERHEAD_ACCOUNT
AND GLC5.CODE_COMBINATION_ID (+) = MSS.OUTSIDE_PROCESSING_ACCOUNT
AND GLC6.CODE_COMBINATION_ID (+) = MSS.EXPENSE_ACCOUNT
AND GLC7.CODE_COMBINATION_ID (+) = MSS.ENCUMBRANCE_ACCOUNT
AND MP1.ORGANIZATION_ID = MSS.ORGANIZATION_ID
AND MP2.ORGANIZATION_ID (+) = MSS.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MSS.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID (+) = MSS.SOURCE_ORGANIZATION_ID
AND '_SEC:MSS.ORGANIZATION_ID' IS NOT NULL
AND (MSS.SUBINVENTORY_TYPE = 1 OR MSS.SUBINVENTORY_TYPE IS NULL) WITH READ ONLY