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.

[Home] [Help]

View: BOM_IMPLOSION_VIEW

Product:	BOM - Bills of Material
Description:	Used for inquiry report
Implementation/DBA Data:	APPS.BOM_IMPLOSION_VIEW

View Text

SELECT T.SEQUENCE_ID
, T.LOWEST_ITEM_ID
, T.SORT_CODE
, T.CURRENT_LEVEL
, T.PARENT_ITEM_ID
, T.ORGANIZATION_ID
, F.ITEM_NUMBER
, F.DESCRIPTION
, I.PRIMARY_UOM_CODE
, T.ALTERNATE_DESIGNATOR
, T.CURRENT_ASSEMBLY_TYPE
, T.OPERATION_SEQ_NUM
, T.EFFECTIVITY_DATE
, T.DISABLE_DATE
, LU.MEANING BASIS_TYPE
, T.COMPONENT_QUANTITY
, T.CHANGE_NOTICE
, T.REVISED_ITEM_SEQUENCE_ID
, F.ITEM_TYPE
, LPAD(CURRENT_LEVEL
, LEAST(CURRENT_LEVEL
, 8)
, '.')
, T.IMPLEMENTED_FLAG
FROM BOM_IMPLOSION_TEMP T
, MTL_ITEM_FLEXFIELDS F
, MTL_SYSTEM_ITEMS_B I
, MFG_LOOKUPS LU
WHERE T.PARENT_ITEM_ID = F.ITEM_ID
AND T.ORGANIZATION_ID = F.ORGANIZATION_ID
AND T.ORGANIZATION_ID = I.ORGANIZATION_ID
AND T.CURRENT_ITEM_ID = I.INVENTORY_ITEM_ID
AND LU.LOOKUP_TYPE (+)='BOM_BASIS_TYPE'
AND LU.LOOKUP_CODE =NVL (T.BASIS_TYPE
, 1)

Columns

Name
SEQUENCE_ID
LOWEST_ITEM_ID
SORT_CODE
CURRENT_LEVEL
PARENT_ITEM_ID
ORGANIZATION_ID
PARENT
PARENT_DESCRIPTION
PARENT_UOM
PARENT_ALTERNATE_DESIGNATOR
PARENT_ENGINEERING_BILL
COMPONENT_OP_SEQ_NUM
COMPONENT_EFFECTIVE_DATE
COMPONENT_DISABLE_DATE
BASIS_TYPE
COMPONENT_QUANTITY
CHANGE_NOTICE
REVISED_ITEM_SEQUENCE_ID
ITEM_TYPE
DISPLAY_PLAN_LEVEL
IMPLEMENTED_FLAG