eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CSP_SUPERSESIONS_V

Source

View Text - Preformatted


SELECT mri1.ROWID ROW_ID , mri2.ROWID REPAIRTO_ROW_ID , mri1.ORGANIZATION_ID ORGANIZATION_ID , mri1.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , mri1.RELATED_ITEM_ID RELATED_ITEM_ID, mri1.RELATIONSHIP_TYPE_ID , mri1.RECIPROCAL_FLAG , mri1.START_DATE START_DATE , mri1.END_DATE END_DATE , mri1.ATTR_CONTEXT ATTR_CONTEXT , mri1.ATTR_CHAR1 ATTR_CHAR1 , mri1.ATTR_CHAR2 ATTR_CHAR2 , mri1.ATTR_CHAR3 ATTR_CHAR3 , mri1.ATTR_CHAR4 ATTR_CHAR4 , mri1.ATTR_CHAR5 ATTR_CHAR5 , mri1.ATTR_CHAR6 ATTR_CHAR6 , mri1.ATTR_CHAR7 ATTR_CHAR7 , mri1.ATTR_CHAR8 ATTR_CHAR8 , mri1.ATTR_CHAR9 ATTR_CHAR9 , mri1.ATTR_CHAR10 ATTR_CHAR10 , mri1.ATTR_NUM1 ATTR_NUM1 , mri1.ATTR_NUM2 ATTR_NUM2 , mri1.ATTR_NUM3 ATTR_NUM3 , mri1.ATTR_NUM4 ATTR_NUM4 , mri1.ATTR_NUM5 ATTR_NUM5 , mri1.ATTR_NUM6 ATTR_NUM6 , mri1.ATTR_NUM7 ATTR_NUM7 , mri1.ATTR_NUM8 ATTR_NUM8 , mri1.ATTR_NUM9 ATTR_NUM9 , mri1.ATTR_NUM10 ATTR_NUM10 , mri1.ATTR_DATE1 ATTR_DATE1 , mri1.ATTR_DATE2 ATTR_DATE2 , mri1.ATTR_DATE3 ATTR_DATE3 , mri1.ATTR_DATE4 ATTR_DATE4 , mri1.ATTR_DATE5 ATTR_DATE5 , mri1.ATTR_DATE6 ATTR_DATE6 , mri1.ATTR_DATE7 ATTR_DATE7 , mri1.ATTR_DATE8 ATTR_DATE8 , mri1.ATTR_DATE9 ATTR_DATE9 , mri1.ATTR_DATE10 ATTR_DATE10 , mri1.LAST_UPDATE_DATE , mri1.LAST_UPDATED_BY , mri1.CREATION_DATE , mri1.CREATED_BY , mri1.LAST_UPDATE_LOGIN , mri1.REQUEST_ID , mri1.PROGRAM_APPLICATION_ID , mri1.PROGRAM_ID , mri1.PROGRAM_UPDATE_DATE, msib1.MTL_TRANSACTIONS_ENABLED_FLAG DISPOSITION, msit1.DESCRIPTION INVENTORY_ITEM_DESCRIPTION , msit2.DESCRIPTION RELATED_ITEM_DESCRIPTION, mri2.RELATED_ITEM_ID REPAIRTO_ITEM_ID, msit3.description repairto_item_description, msib1.concatenated_segments REPLACED_ITEM_NUMBER, msib2.concatenated_segments RELATED_ITEM_NUMBER, msib3.concatenated_segments REPAIRTO_ITEM_NUMBER FROM (select * from MTL_RELATED_ITEMS where relationship_type_id = 8) mri1, (select * from MTL_RELATED_ITEMS where relationship_type_id = 18) mri2, MTL_SYSTEM_ITEMS_TL msit1, MTL_SYSTEM_ITEMS_TL msit2, MTL_SYSTEM_ITEMS_TL msit3, MTL_SYSTEM_ITEMS_B_KFV msib1, MTL_SYSTEM_ITEMS_B_KFV msib2, MTL_SYSTEM_ITEMS_B_KFV msib3 WHERE mri1.INVENTORY_ITEM_ID = msit1.INVENTORY_ITEM_ID AND mri1.ORGANIZATION_ID = msit1.ORGANIZATION_ID AND msit1.LANGUAGE = userenv('LANG') AND mri1.RELATED_ITEM_ID = msit2.INVENTORY_ITEM_ID AND mri1.ORGANIZATION_ID = msit2.ORGANIZATION_ID AND msit2.LANGUAGE = userenv('LANG') AND msib1.inventory_item_id = mri1.INVENTORY_ITEM_ID AND msib1.organization_id = mri1.organization_id AND mri2.inventory_item_id(+) = mri1.inventory_item_id AND mri2.organization_id (+) = mri1.organization_id AND msit3.inventory_item_id(+) = mri2.related_item_id And msit3.organization_id(+) = mri2.organization_id And msit3.language(+) = userenv('LANG') AND msib2.inventory_item_id = mri1.RELATED_ITEM_ID AND msib2.organization_id = mri1.organization_id AND msib3.inventory_item_id(+) = mri2.RELATED_ITEM_ID AND msib3.organization_id(+) = mri2.organization_id

View Text - HTML Formatted

SELECT MRI1.ROWID ROW_ID
, MRI2.ROWID REPAIRTO_ROW_ID
, MRI1.ORGANIZATION_ID ORGANIZATION_ID
, MRI1.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MRI1.RELATED_ITEM_ID RELATED_ITEM_ID
, MRI1.RELATIONSHIP_TYPE_ID
, MRI1.RECIPROCAL_FLAG
, MRI1.START_DATE START_DATE
, MRI1.END_DATE END_DATE
, MRI1.ATTR_CONTEXT ATTR_CONTEXT
, MRI1.ATTR_CHAR1 ATTR_CHAR1
, MRI1.ATTR_CHAR2 ATTR_CHAR2
, MRI1.ATTR_CHAR3 ATTR_CHAR3
, MRI1.ATTR_CHAR4 ATTR_CHAR4
, MRI1.ATTR_CHAR5 ATTR_CHAR5
, MRI1.ATTR_CHAR6 ATTR_CHAR6
, MRI1.ATTR_CHAR7 ATTR_CHAR7
, MRI1.ATTR_CHAR8 ATTR_CHAR8
, MRI1.ATTR_CHAR9 ATTR_CHAR9
, MRI1.ATTR_CHAR10 ATTR_CHAR10
, MRI1.ATTR_NUM1 ATTR_NUM1
, MRI1.ATTR_NUM2 ATTR_NUM2
, MRI1.ATTR_NUM3 ATTR_NUM3
, MRI1.ATTR_NUM4 ATTR_NUM4
, MRI1.ATTR_NUM5 ATTR_NUM5
, MRI1.ATTR_NUM6 ATTR_NUM6
, MRI1.ATTR_NUM7 ATTR_NUM7
, MRI1.ATTR_NUM8 ATTR_NUM8
, MRI1.ATTR_NUM9 ATTR_NUM9
, MRI1.ATTR_NUM10 ATTR_NUM10
, MRI1.ATTR_DATE1 ATTR_DATE1
, MRI1.ATTR_DATE2 ATTR_DATE2
, MRI1.ATTR_DATE3 ATTR_DATE3
, MRI1.ATTR_DATE4 ATTR_DATE4
, MRI1.ATTR_DATE5 ATTR_DATE5
, MRI1.ATTR_DATE6 ATTR_DATE6
, MRI1.ATTR_DATE7 ATTR_DATE7
, MRI1.ATTR_DATE8 ATTR_DATE8
, MRI1.ATTR_DATE9 ATTR_DATE9
, MRI1.ATTR_DATE10 ATTR_DATE10
, MRI1.LAST_UPDATE_DATE
, MRI1.LAST_UPDATED_BY
, MRI1.CREATION_DATE
, MRI1.CREATED_BY
, MRI1.LAST_UPDATE_LOGIN
, MRI1.REQUEST_ID
, MRI1.PROGRAM_APPLICATION_ID
, MRI1.PROGRAM_ID
, MRI1.PROGRAM_UPDATE_DATE
, MSIB1.MTL_TRANSACTIONS_ENABLED_FLAG DISPOSITION
, MSIT1.DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, MSIT2.DESCRIPTION RELATED_ITEM_DESCRIPTION
, MRI2.RELATED_ITEM_ID REPAIRTO_ITEM_ID
, MSIT3.DESCRIPTION REPAIRTO_ITEM_DESCRIPTION
, MSIB1.CONCATENATED_SEGMENTS REPLACED_ITEM_NUMBER
, MSIB2.CONCATENATED_SEGMENTS RELATED_ITEM_NUMBER
, MSIB3.CONCATENATED_SEGMENTS REPAIRTO_ITEM_NUMBER
FROM (SELECT *
FROM MTL_RELATED_ITEMS
WHERE RELATIONSHIP_TYPE_ID = 8) MRI1
, (SELECT *
FROM MTL_RELATED_ITEMS
WHERE RELATIONSHIP_TYPE_ID = 18) MRI2
, MTL_SYSTEM_ITEMS_TL MSIT1
, MTL_SYSTEM_ITEMS_TL MSIT2
, MTL_SYSTEM_ITEMS_TL MSIT3
, MTL_SYSTEM_ITEMS_B_KFV MSIB1
, MTL_SYSTEM_ITEMS_B_KFV MSIB2
, MTL_SYSTEM_ITEMS_B_KFV MSIB3
WHERE MRI1.INVENTORY_ITEM_ID = MSIT1.INVENTORY_ITEM_ID
AND MRI1.ORGANIZATION_ID = MSIT1.ORGANIZATION_ID
AND MSIT1.LANGUAGE = USERENV('LANG')
AND MRI1.RELATED_ITEM_ID = MSIT2.INVENTORY_ITEM_ID
AND MRI1.ORGANIZATION_ID = MSIT2.ORGANIZATION_ID
AND MSIT2.LANGUAGE = USERENV('LANG')
AND MSIB1.INVENTORY_ITEM_ID = MRI1.INVENTORY_ITEM_ID
AND MSIB1.ORGANIZATION_ID = MRI1.ORGANIZATION_ID
AND MRI2.INVENTORY_ITEM_ID(+) = MRI1.INVENTORY_ITEM_ID
AND MRI2.ORGANIZATION_ID (+) = MRI1.ORGANIZATION_ID
AND MSIT3.INVENTORY_ITEM_ID(+) = MRI2.RELATED_ITEM_ID
AND MSIT3.ORGANIZATION_ID(+) = MRI2.ORGANIZATION_ID
AND MSIT3.LANGUAGE(+) = USERENV('LANG')
AND MSIB2.INVENTORY_ITEM_ID = MRI1.RELATED_ITEM_ID
AND MSIB2.ORGANIZATION_ID = MRI1.ORGANIZATION_ID
AND MSIB3.INVENTORY_ITEM_ID(+) = MRI2.RELATED_ITEM_ID
AND MSIB3.ORGANIZATION_ID(+) = MRI2.ORGANIZATION_ID