[Home] [Help]
View: ENG_WEB_SUB_COMPS_V
Product: | ENG - Engineering |
Description: | Revised substitute components designed for use in Oracle self service web applications |
Implementation/DBA Data: |
APPS.ENG_WEB_SUB_COMPS_V
|
View Text
SELECT BSC.COMPONENT_SEQUENCE_ID
, ML.MEANING ACTION
, MSI.CONCATENATED_SEGMENTS SUBSTITUTE_COMPONENT
, MSI.PADDED_CONCATENATED_SEGMENTS
, BSC.SUBSTITUTE_ITEM_QUANTITY
, MSI.PRIMARY_UOM_CODE
, MSI.DESCRIPTION
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MFG_LOOKUPS ML
, BOM_SUBSTITUTE_COMPONENTS BSC
, ENG_REVISED_ITEMS ERI
, BOM_INVENTORY_COMPONENTS BIC
WHERE BIC.COMPONENT_SEQUENCE_ID = BSC.COMPONENT_SEQUENCE_ID
AND BIC.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND BSC.CHANGE_NOTICE = ERI.CHANGE_NOTICE
AND MSI.INVENTORY_ITEM_ID = BSC.SUBSTITUTE_COMPONENT_ID
AND MSI.ORGANIZATION_ID = ERI.ORGANIZATION_ID
AND ML.LOOKUP_CODE = BSC.ACD_TYPE
AND ML.LOOKUP_TYPE = 'ENG_REF_DESIG_ACTION'
Columns
Name |
COMPONENT_SEQUENCE_ID |
ACTION |
SUBSTITUTE_COMPONENT |
PADDED_CONCATENATED_SEGMENTS |
SUBSTITUTE_ITEM_QUANTITY |
PRIMARY_UOM_CODE |
DESCRIPTION |