View: ENG_WEB_REVISED_COMPS_V

Product:	ENG - Engineering
Description:	Revised component on an ECO designed for use in Oracle self service web applications
Implementation/DBA Data:	APPS.ENG_WEB_REVISED_COMPS_V

View Text

SELECT A.REVISED_ITEM_SEQUENCE_ID
, A.OPERATION_SEQUENCE_NUM
, A.ITEM_NUM
, MSI.PADDED_CONCATENATED_SEGMENTS
, MSI2.CONCATENATED_SEGMENTS REVISED_ITEM
, ML.MEANING ACTION
, A.COMPONENT_ITEM_ID
, ERI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MSI.CONCATENATED_SEGMENTS COMPONENT_ITEM
, MSI.DESCRIPTION
, MSI.ENG_ITEM_FLAG
, MSI.PRIMARY_UOM_CODE
, A2.OPERATION_SEQ_NUM OLD_OP_SEQ_NUM
, A.EFFECTIVITY_DATE
, TO_CHAR(A.EFFECTIVITY_DATE
, 'HH24:MI:SS') EFFECTIVITY_TIME
, A.COMPONENT_QUANTITY
, ERI.CHANGE_NOTICE
, A.COMPONENT_SEQUENCE_ID
FROM BOM_INVENTORY_COMPONENTS A2
, MTL_SYSTEM_ITEMS_KFV MSI
, MFG_LOOKUPS ML
, ENG_REVISED_COMPONENTS A
, MTL_SYSTEM_ITEMS_KFV MSI2
, MTL_PARAMETERS MP
, ENG_REVISED_ITEMS ERI
WHERE A.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND A.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND ERI.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ERI.REVISED_ITEM_ID = MSI2.INVENTORY_ITEM_ID
AND ERI.ORGANIZATION_ID = MSI2.ORGANIZATION_ID
AND ML.LOOKUP_CODE = A.ACD_TYPE
AND ML.LOOKUP_TYPE = 'ECG_ACTION'
AND A.OLD_COMPONENT_SEQUENCE_ID = A2.COMPONENT_SEQUENCE_ID
AND MP.ORGANIZATION_ID = ERI.ORGANIZATION_ID UNION SELECT B.REVISED_ITEM_SEQUENCE_ID
, B.OPERATION_SEQ_NUM
, B.ITEM_NUM
, MSI.PADDED_CONCATENATED_SEGMENTS
, MSI2.CONCATENATED_SEGMENTS REVISED_ITEM
, ML.MEANING ACTION
, B.COMPONENT_ITEM_ID
, ERI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MSI.CONCATENATED_SEGMENTS COMPONENT_ITEM
, MSI.DESCRIPTION
, MSI.ENG_ITEM_FLAG
, MSI.PRIMARY_UOM_CODE
, B2.OPERATION_SEQ_NUM OLD_OP_SEQ_NUM
, B.EFFECTIVITY_DATE
, TO_CHAR(B.EFFECTIVITY_DATE
, 'HH24:MI:SS') EFFECTIVITY_TIME
, B.COMPONENT_QUANTITY
, ERI.CHANGE_NOTICE
, B.COMPONENT_SEQUENCE_ID
FROM BOM_INVENTORY_COMPONENTS B2
, MTL_SYSTEM_ITEMS_KFV MSI
, MFG_LOOKUPS ML
, BOM_INVENTORY_COMPONENTS B
, MTL_SYSTEM_ITEMS_KFV MSI2
, MTL_PARAMETERS MP
, ENG_REVISED_ITEMS ERI
WHERE B.IMPLEMENTATION_DATE IS NULL
AND B.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID
AND B.COMPONENT_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND ERI.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND ERI.REVISED_ITEM_ID = MSI2.INVENTORY_ITEM_ID
AND ERI.ORGANIZATION_ID = MSI2.ORGANIZATION_ID
AND ML.LOOKUP_CODE = B.ACD_TYPE
AND ML.LOOKUP_TYPE = 'ECG_ACTION'
AND MP.ORGANIZATION_ID = ERI.ORGANIZATION_ID
AND B.OLD_COMPONENT_SEQUENCE_ID = B2.COMPONENT_SEQUENCE_ID

Columns