[Home] [Help]
View: BOM_SUB_COMPS_QF_V
Product: | BOM - Bills of Material |
Description: | View for substitute components list of values |
Implementation/DBA Data: |
APPS.BOM_SUB_COMPS_QF_V
|
View Text
SELECT BSC.SUBSTITUTE_COMPONENT_ID
, BSC.COMPONENT_SEQUENCE_ID
, BSC.ACD_TYPE
, MIF.ITEM_NUMBER
, MIF.DESCRIPTION
FROM BOM_SUBSTITUTE_COMPONENTS BSC
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
, MTL_ITEM_FLEXFIELDS MIF
WHERE BSC.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID
AND BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
AND BOM.ORGANIZATION_ID = MIF.ORGANIZATION_ID
AND BSC.SUBSTITUTE_COMPONENT_ID = MIF.INVENTORY_ITEM_ID
AND NVL(BSC.ACD_TYPE
, 1) <> 3
Columns
Name |
SUBSTITUTE_COMPONENT_ID |
COMPONENT_SEQUENCE_ID |
ACD_TYPE |
ITEM_NUMBER |
DESCRIPTION |