Product: | BOM - Bills of Material |
---|---|
Description: | Used for inquiry window |
Implementation/DBA Data: | APPS.BOM_IMPL_INQUIRY_VIEW |
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
, TO_CHAR(T.EFFECTIVITY_DATE
, 'HH24:MI')
, T.DISABLE_DATE
, TO_CHAR(T.DISABLE_DATE
, 'HH24:MI')
, 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_SMALL_IMPL_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)