[Home] [Help]
View: CS_SR_INV_COMPONENTS_V
Product: | CS - Service |
Description: | This view shows all inventory components from BOM. |
Implementation/DBA Data: |
APPS.CS_SR_INV_COMPONENTS_V
|
View Text
SELECT KFV.ORGANIZATION_ID
, KFV.INVENTORY_ITEM_ID COMPONENT_ID
, KFV.DESCRIPTION DESCRIPTION
, KFV.CONCATENATED_SEGMENTS
, MTL.INVENTORY_ITEM_ID
FROM MTL_SYSTEM_ITEMS_VL KFV
, BOM_INVENTORY_COMPONENTS BIC
, BOM_BILL_OF_MATERIALS BOM
, MTL_SYSTEM_ITEMS MTL
WHERE BOM.ORGANIZATION_ID = KFV.ORGANIZATION_ID AND BIC.BILL_SEQUENCE_ID = BOM.COMMON_BILL_SEQUENCE_ID AND TRUNC(SYSDATE) BETWEEN TRUNC(BIC.EFFECTIVITY_DATE)
AND NVL(BIC.DISABLE_DATE
, TRUNC(SYSDATE))
AND KFV.INVENTORY_ITEM_ID = BIC.COMPONENT_ITEM_ID
AND MTL.ORGANIZATION_ID = KFV.ORGANIZATION_ID AND MTL.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID
AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
Columns
Name |
ORGANIZATION_ID |
COMPONENT_ID |
DESCRIPTION |
CONCATENATED_SEGMENTS |
INVENTORY_ITEM_ID |