VIEW: APPS.ENG_WEB_REVISED_COMPS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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