VIEW: APPS.BOMBV_BILL_OF_MATERIALS

Source

View Text - Preformatted

SELECT BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , '_KF:INV:MSTK:SY' "_KF:BILL_ITEM_NAME" , BI.SPECIFIC_ASSEMBLY_COMMENT DESCRIPTION , BI.PENDING_FROM_ECN PENDING_FROM_ECO , '_LA:BI.ASSEMBLY_TYPE:MFG_LOOKUPS:ECG_BOM_COMP_SEL:MEANING' , BI.ASSEMBLY_ITEM_ID , BI.ORGANIZATION_ID , BI.BILL_SEQUENCE_ID , BI.COMMON_ASSEMBLY_ITEM_ID , BI.COMMON_BILL_SEQUENCE_ID , BI.COMMON_ORGANIZATION_ID , BI.LAST_UPDATE_DATE , BI.LAST_UPDATED_BY , BI.CREATION_DATE , BI.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL, MTL_PARAMETERS PA, MTL_SYSTEM_ITEMS SY, BOM_BILL_OF_MATERIALS BI WHERE BI.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID AND BI.ORGANIZATION_ID = SY.ORGANIZATION_ID AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:bi.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY' "_KF:BILL_ITEM_NAME"
, BI.SPECIFIC_ASSEMBLY_COMMENT DESCRIPTION
, BI.PENDING_FROM_ECN PENDING_FROM_ECO
, '_LA:BI.ASSEMBLY_TYPE:MFG_LOOKUPS:ECG_BOM_COMP_SEL:MEANING'
, BI.ASSEMBLY_ITEM_ID
, BI.ORGANIZATION_ID
, BI.BILL_SEQUENCE_ID
, BI.COMMON_ASSEMBLY_ITEM_ID
, BI.COMMON_BILL_SEQUENCE_ID
, BI.COMMON_ORGANIZATION_ID
, BI.LAST_UPDATE_DATE
, BI.LAST_UPDATED_BY
, BI.CREATION_DATE
, BI.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS SY
, BOM_BILL_OF_MATERIALS BI
WHERE BI.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY