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.AHL_UNIT_CONFIG_HEADERS_V

Source

View Text - Preformatted


SELECT U.UNIT_CONFIG_HEADER_ID, U.OBJECT_VERSION_NUMBER, U.CREATION_DATE, U.CREATED_BY, U.LAST_UPDATE_DATE, U.LAST_UPDATED_BY, U.LAST_UPDATE_LOGIN, U.NAME, U.MASTER_CONFIG_ID, M.NAME, M.REVISION, M.CONFIG_STATUS_CODE, MCSC.MEANING, MT.DESCRIPTION, R.POSITION_REF_CODE, MRSC.MEANING, R.ACTIVE_START_DATE, R.ACTIVE_END_DATE, U.CSI_ITEM_INSTANCE_ID, C.OBJECT_VERSION_NUMBER, I.CONCATENATED_SEGMENTS, C.INSTANCE_NUMBER, C.SERIAL_NUMBER, C.LOT_NUMBER, C.ACTIVE_START_DATE, C.ACTIVE_END_DATE, U.ACTIVE_START_DATE, U.ACTIVE_END_DATE, U.UNIT_CONFIG_STATUS_CODE, UCSC.MEANING, U.ACTIVE_UC_STATUS_CODE, UASC.MEANING, U.PARENT_UC_HEADER_ID, PU.NAME, CR.object_id, (select unit_config_header_id from ahl_unit_config_headers where parent_uc_header_id is null start with unit_config_header_id = U.unit_config_header_id connect by unit_config_header_id = prior parent_uc_header_id), U.ATTRIBUTE_CATEGORY, U.ATTRIBUTE1, U.ATTRIBUTE2, U.ATTRIBUTE3, U.ATTRIBUTE4, U.ATTRIBUTE5, U.ATTRIBUTE6, U.ATTRIBUTE7, U.ATTRIBUTE8, U.ATTRIBUTE9, U.ATTRIBUTE10, U.ATTRIBUTE11, U.ATTRIBUTE12, U.ATTRIBUTE13, U.ATTRIBUTE14, U.ATTRIBUTE15 FROM AHL_UNIT_CONFIG_HEADERS U, CSI_ITEM_INSTANCES C, MTL_SYSTEM_ITEMS_KFV I, AHL_MC_HEADERS_B M, AHL_MC_HEADERS_TL MT, AHL_MC_RELATIONSHIPS R, AHL_UNIT_CONFIG_HEADERS PU, CSI_II_RELATIONSHIPS CR, FND_LOOKUP_VALUES UCSC, FND_LOOKUP_VALUES UASC, FND_LOOKUP_VALUES MCSC, FND_LOOKUP_VALUES MRSC WHERE U.csi_item_instance_id = C.instance_id AND U.master_config_id = M.mc_header_id AND C.inventory_item_id = I.inventory_item_id AND C.inv_master_organization_id = I.organization_id AND M.mc_header_id = MT.mc_header_id AND MT.language = USERENV('LANG') AND M.mc_header_id = R.mc_header_id AND R.parent_relationship_id is NULL AND U.parent_uc_header_id = PU.unit_config_header_id (+) AND U.unit_config_status_code = UCSC.lookup_code AND 'AHL_CONFIG_STATUS' = UCSC.lookup_type AND UCSC.language = USERENV('LANG') AND U.active_uc_status_code = UASC.lookup_code (+) AND 'AHL_CONFIG_STATUS' = UASC.lookup_type (+) AND UASC.language (+) = USERENV('LANG') AND M.config_status_code = MCSC.lookup_code AND 'AHL_CONFIG_STATUS' = MCSC.lookup_type AND MCSC.language = USERENV('LANG') AND R.position_ref_code = MRSC.lookup_code AND 'AHL_POSITION_REFERENCE' = MRSC.lookup_type AND MRSC.language = USERENV('LANG') AND U.csi_item_instance_id = CR.subject_id (+) AND CR.relationship_type_code (+) = 'COMPONENT-OF' AND trunc(nvl(CR.active_end_date (+), SYSDATE+1)) > trunc(SYSDATE) AND EXISTS (SELECT 1 FROM inv_organization_info_v O, mtl_parameters mp WHERE I.organization_id = mp.master_organization_id AND mp.organization_id = O.organization_id AND NVL(O.operating_unit,mo_global.get_current_org_id()) = mo_global.get_current_org_id())

View Text - HTML Formatted

SELECT U.UNIT_CONFIG_HEADER_ID
, U.OBJECT_VERSION_NUMBER
, U.CREATION_DATE
, U.CREATED_BY
, U.LAST_UPDATE_DATE
, U.LAST_UPDATED_BY
, U.LAST_UPDATE_LOGIN
, U.NAME
, U.MASTER_CONFIG_ID
, M.NAME
, M.REVISION
, M.CONFIG_STATUS_CODE
, MCSC.MEANING
, MT.DESCRIPTION
, R.POSITION_REF_CODE
, MRSC.MEANING
, R.ACTIVE_START_DATE
, R.ACTIVE_END_DATE
, U.CSI_ITEM_INSTANCE_ID
, C.OBJECT_VERSION_NUMBER
, I.CONCATENATED_SEGMENTS
, C.INSTANCE_NUMBER
, C.SERIAL_NUMBER
, C.LOT_NUMBER
, C.ACTIVE_START_DATE
, C.ACTIVE_END_DATE
, U.ACTIVE_START_DATE
, U.ACTIVE_END_DATE
, U.UNIT_CONFIG_STATUS_CODE
, UCSC.MEANING
, U.ACTIVE_UC_STATUS_CODE
, UASC.MEANING
, U.PARENT_UC_HEADER_ID
, PU.NAME
, CR.OBJECT_ID
, (SELECT UNIT_CONFIG_HEADER_ID
FROM AHL_UNIT_CONFIG_HEADERS
WHERE PARENT_UC_HEADER_ID IS NULL START WITH UNIT_CONFIG_HEADER_ID = U.UNIT_CONFIG_HEADER_ID CONNECT BY UNIT_CONFIG_HEADER_ID = PRIOR PARENT_UC_HEADER_ID)
, U.ATTRIBUTE_CATEGORY
, U.ATTRIBUTE1
, U.ATTRIBUTE2
, U.ATTRIBUTE3
, U.ATTRIBUTE4
, U.ATTRIBUTE5
, U.ATTRIBUTE6
, U.ATTRIBUTE7
, U.ATTRIBUTE8
, U.ATTRIBUTE9
, U.ATTRIBUTE10
, U.ATTRIBUTE11
, U.ATTRIBUTE12
, U.ATTRIBUTE13
, U.ATTRIBUTE14
, U.ATTRIBUTE15
FROM AHL_UNIT_CONFIG_HEADERS U
, CSI_ITEM_INSTANCES C
, MTL_SYSTEM_ITEMS_KFV I
, AHL_MC_HEADERS_B M
, AHL_MC_HEADERS_TL MT
, AHL_MC_RELATIONSHIPS R
, AHL_UNIT_CONFIG_HEADERS PU
, CSI_II_RELATIONSHIPS CR
, FND_LOOKUP_VALUES UCSC
, FND_LOOKUP_VALUES UASC
, FND_LOOKUP_VALUES MCSC
, FND_LOOKUP_VALUES MRSC
WHERE U.CSI_ITEM_INSTANCE_ID = C.INSTANCE_ID
AND U.MASTER_CONFIG_ID = M.MC_HEADER_ID
AND C.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND C.INV_MASTER_ORGANIZATION_ID = I.ORGANIZATION_ID
AND M.MC_HEADER_ID = MT.MC_HEADER_ID
AND MT.LANGUAGE = USERENV('LANG')
AND M.MC_HEADER_ID = R.MC_HEADER_ID
AND R.PARENT_RELATIONSHIP_ID IS NULL
AND U.PARENT_UC_HEADER_ID = PU.UNIT_CONFIG_HEADER_ID (+)
AND U.UNIT_CONFIG_STATUS_CODE = UCSC.LOOKUP_CODE
AND 'AHL_CONFIG_STATUS' = UCSC.LOOKUP_TYPE
AND UCSC.LANGUAGE = USERENV('LANG')
AND U.ACTIVE_UC_STATUS_CODE = UASC.LOOKUP_CODE (+)
AND 'AHL_CONFIG_STATUS' = UASC.LOOKUP_TYPE (+)
AND UASC.LANGUAGE (+) = USERENV('LANG')
AND M.CONFIG_STATUS_CODE = MCSC.LOOKUP_CODE
AND 'AHL_CONFIG_STATUS' = MCSC.LOOKUP_TYPE
AND MCSC.LANGUAGE = USERENV('LANG')
AND R.POSITION_REF_CODE = MRSC.LOOKUP_CODE
AND 'AHL_POSITION_REFERENCE' = MRSC.LOOKUP_TYPE
AND MRSC.LANGUAGE = USERENV('LANG')
AND U.CSI_ITEM_INSTANCE_ID = CR.SUBJECT_ID (+)
AND CR.RELATIONSHIP_TYPE_CODE (+) = 'COMPONENT-OF'
AND TRUNC(NVL(CR.ACTIVE_END_DATE (+)
, SYSDATE+1)) > TRUNC(SYSDATE)
AND EXISTS (SELECT 1
FROM INV_ORGANIZATION_INFO_V O
, MTL_PARAMETERS MP
WHERE I.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MP.ORGANIZATION_ID = O.ORGANIZATION_ID
AND NVL(O.OPERATING_UNIT
, MO_GLOBAL.GET_CURRENT_ORG_ID()) = MO_GLOBAL.GET_CURRENT_ORG_ID())