VIEW: APPS.BOM_IMPLOSION_VIEW

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)