VIEW: APPS.AHL_UNIT_SCHEDULES_V

Source

View Text - Preformatted

SELECT US.UNIT_SCHEDULE_ID, US.OBJECT_VERSION_NUMBER, US.FLIGHT_NUMBER, US.SEGMENT, US.DEPARTURE_DEPT_ID, BDPTD.DEPARTMENT_CODE, US.DEPARTURE_ORG_ID, MPD.ORGANIZATION_CODE, US.ARRIVAL_DEPT_ID, BDPTA.DEPARTMENT_CODE, US.ARRIVAL_ORG_ID, MPA.ORGANIZATION_CODE, US.EST_DEPARTURE_TIME, US.EST_ARRIVAL_TIME, US.ACTUAL_DEPARTURE_TIME, US.ACTUAL_ARRIVAL_TIME, US.PRECEDING_US_ID, US.UNIT_CONFIG_HEADER_ID, UCH.NAME, US.VISIT_RESCHEDULE_MODE, VR.MEANING, UCH.CSI_ITEM_INSTANCE_ID, CI.INSTANCE_NUMBER, MTLS.CONCATENATED_SEGMENTS, CI.SERIAL_NUMBER, UCH.UNIT_CONFIG_STATUS_CODE, UCST.MEANING, UCH.ACTIVE_START_DATE, UCH.ACTIVE_END_DATE, US.ATTRIBUTE_CATEGORY, US.ATTRIBUTE1, US.ATTRIBUTE2, US.ATTRIBUTE3, US.ATTRIBUTE4, US.ATTRIBUTE5, US.ATTRIBUTE6, US.ATTRIBUTE7, US.ATTRIBUTE8, US.ATTRIBUTE9, US.ATTRIBUTE10, US.ATTRIBUTE11, US.ATTRIBUTE12, US.ATTRIBUTE13, US.ATTRIBUTE14, US.ATTRIBUTE15 FROM AHL_UNIT_SCHEDULES US, AHL_UNIT_CONFIG_HEADERS UCH, CSI_ITEM_INSTANCES CI, MTL_SYSTEM_ITEMS_KFV MTLS, MTL_PARAMETERS MPA, BOM_DEPARTMENTS BDPTA, MTL_PARAMETERS MPD, BOM_DEPARTMENTS BDPTD, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_CONFIG_STATUS' AND LANGUAGE = USERENV('LANG')) UCST, (SELECT LOOKUP_CODE, MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'AHL_UA_VISIT_SYNC_RULE' AND LANGUAGE = USERENV('LANG')) VR WHERE US.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID AND UCH.UNIT_CONFIG_STATUS_CODE = UCST.LOOKUP_CODE AND UCH.CSI_ITEM_INSTANCE_ID = CI.INSTANCE_ID AND CI.INVENTORY_ITEM_ID = MTLS.INVENTORY_ITEM_ID AND CI.LAST_VLD_ORGANIZATION_ID = MTLS.ORGANIZATION_ID AND US.ARRIVAL_ORG_ID = MPA.ORGANIZATION_ID AND US.ARRIVAL_DEPT_ID = BDPTA.DEPARTMENT_ID AND US.DEPARTURE_ORG_ID = MPD.ORGANIZATION_ID AND US.DEPARTURE_DEPT_ID = BDPTD.DEPARTMENT_ID AND US.VISIT_RESCHEDULE_MODE = VR.LOOKUP_CODE

View Text - HTML Formatted

SELECT US.UNIT_SCHEDULE_ID
, US.OBJECT_VERSION_NUMBER
, US.FLIGHT_NUMBER
, US.SEGMENT
, US.DEPARTURE_DEPT_ID
, BDPTD.DEPARTMENT_CODE
, US.DEPARTURE_ORG_ID
, MPD.ORGANIZATION_CODE
, US.ARRIVAL_DEPT_ID
, BDPTA.DEPARTMENT_CODE
, US.ARRIVAL_ORG_ID
, MPA.ORGANIZATION_CODE
, US.EST_DEPARTURE_TIME
, US.EST_ARRIVAL_TIME
, US.ACTUAL_DEPARTURE_TIME
, US.ACTUAL_ARRIVAL_TIME
, US.PRECEDING_US_ID
, US.UNIT_CONFIG_HEADER_ID
, UCH.NAME
, US.VISIT_RESCHEDULE_MODE
, VR.MEANING
, UCH.CSI_ITEM_INSTANCE_ID
, CI.INSTANCE_NUMBER
, MTLS.CONCATENATED_SEGMENTS
, CI.SERIAL_NUMBER
, UCH.UNIT_CONFIG_STATUS_CODE
, UCST.MEANING
, UCH.ACTIVE_START_DATE
, UCH.ACTIVE_END_DATE
, US.ATTRIBUTE_CATEGORY
, US.ATTRIBUTE1
, US.ATTRIBUTE2
, US.ATTRIBUTE3
, US.ATTRIBUTE4
, US.ATTRIBUTE5
, US.ATTRIBUTE6
, US.ATTRIBUTE7
, US.ATTRIBUTE8
, US.ATTRIBUTE9
, US.ATTRIBUTE10
, US.ATTRIBUTE11
, US.ATTRIBUTE12
, US.ATTRIBUTE13
, US.ATTRIBUTE14
, US.ATTRIBUTE15
FROM AHL_UNIT_SCHEDULES US
, AHL_UNIT_CONFIG_HEADERS UCH
, CSI_ITEM_INSTANCES CI
, MTL_SYSTEM_ITEMS_KFV MTLS
, MTL_PARAMETERS MPA
, BOM_DEPARTMENTS BDPTA
, MTL_PARAMETERS MPD
, BOM_DEPARTMENTS BDPTD
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_CONFIG_STATUS'
AND LANGUAGE = USERENV('LANG')) UCST
, (SELECT LOOKUP_CODE
, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'AHL_UA_VISIT_SYNC_RULE'
AND LANGUAGE = USERENV('LANG')) VR
WHERE US.UNIT_CONFIG_HEADER_ID = UCH.UNIT_CONFIG_HEADER_ID
AND UCH.UNIT_CONFIG_STATUS_CODE = UCST.LOOKUP_CODE
AND UCH.CSI_ITEM_INSTANCE_ID = CI.INSTANCE_ID
AND CI.INVENTORY_ITEM_ID = MTLS.INVENTORY_ITEM_ID
AND CI.LAST_VLD_ORGANIZATION_ID = MTLS.ORGANIZATION_ID
AND US.ARRIVAL_ORG_ID = MPA.ORGANIZATION_ID
AND US.ARRIVAL_DEPT_ID = BDPTA.DEPARTMENT_ID
AND US.DEPARTURE_ORG_ID = MPD.ORGANIZATION_ID
AND US.DEPARTURE_DEPT_ID = BDPTD.DEPARTMENT_ID
AND US.VISIT_RESCHEDULE_MODE = VR.LOOKUP_CODE