VIEW: APPS.AHL_OPERATIONS_H_VL

Source

View Text - Preformatted

SELECT AHOP.ROWID ROW_ID, AHOP.Operations_h_id, AHOP.Object_version_number, AHOP.Last_update_date, AHOP.Last_updated_by, AHOP.Creation_date, AHOP.Created_by, AHOP.Last_update_login, AHOP.Operation_id, AHOP.Revision_number, AHOP.Revision_status_code, AHOP.Standard_operation_flag, AHOPTL.Operation_description, AHOP.Active_start_date, AHOP.Active_end_date, AHOP.Operation_number, AHOP.Segment1, AHOP.Segment2, AHOP.Segment3, AHOP.Segment4, AHOP.Segment5, AHOP.Segment6, AHOP.Segment7, AHOP.Product_type_code, AHOP.Zone_code, AHOP.Sub_zone_code, AHOP.Operation_category_code, AHOP.Operation_Type_code, AHOP.Work_Center_code, AHOP.System_code1, AHOP.System_code2, AHOP.System_code3, AHOP.Process_code, AHOP.Operator_party_id, AHOP.skill_competence_id, AHOP.time_span, AHOPTL.Remarks, AHOPTL.Note, AHOP.ATTRIBUTE_CATEGORY, AHOP.ATTRIBUTE1, AHOP.ATTRIBUTE2, AHOP.ATTRIBUTE3, AHOP.ATTRIBUTE4, AHOP.ATTRIBUTE5, AHOP.ATTRIBUTE6, AHOP.ATTRIBUTE7, AHOP.ATTRIBUTE8, AHOP.ATTRIBUTE9, AHOP.ATTRIBUTE10, AHOP.ATTRIBUTE11, AHOP.ATTRIBUTE12, AHOP.ATTRIBUTE13, AHOP.ATTRIBUTE14, AHOP.ATTRIBUTE15 FROM AHL_OPERATIONS_H_B AHOP, AHL_OPERATIONS_H_TL AHOPTL WHERE AHOP. Operations_h_id = AHOPTL. Operations_h_id AND AHOPTL.LANGUAGE =USERENV('LANG')

View Text - HTML Formatted

SELECT AHOP.ROWID ROW_ID
, AHOP.OPERATIONS_H_ID
, AHOP.OBJECT_VERSION_NUMBER
, AHOP.LAST_UPDATE_DATE
, AHOP.LAST_UPDATED_BY
, AHOP.CREATION_DATE
, AHOP.CREATED_BY
, AHOP.LAST_UPDATE_LOGIN
, AHOP.OPERATION_ID
, AHOP.REVISION_NUMBER
, AHOP.REVISION_STATUS_CODE
, AHOP.STANDARD_OPERATION_FLAG
, AHOPTL.OPERATION_DESCRIPTION
, AHOP.ACTIVE_START_DATE
, AHOP.ACTIVE_END_DATE
, AHOP.OPERATION_NUMBER
, AHOP.SEGMENT1
, AHOP.SEGMENT2
, AHOP.SEGMENT3
, AHOP.SEGMENT4
, AHOP.SEGMENT5
, AHOP.SEGMENT6
, AHOP.SEGMENT7
, AHOP.PRODUCT_TYPE_CODE
, AHOP.ZONE_CODE
, AHOP.SUB_ZONE_CODE
, AHOP.OPERATION_CATEGORY_CODE
, AHOP.OPERATION_TYPE_CODE
, AHOP.WORK_CENTER_CODE
, AHOP.SYSTEM_CODE1
, AHOP.SYSTEM_CODE2
, AHOP.SYSTEM_CODE3
, AHOP.PROCESS_CODE
, AHOP.OPERATOR_PARTY_ID
, AHOP.SKILL_COMPETENCE_ID
, AHOP.TIME_SPAN
, AHOPTL.REMARKS
, AHOPTL.NOTE
, AHOP.ATTRIBUTE_CATEGORY
, AHOP.ATTRIBUTE1
, AHOP.ATTRIBUTE2
, AHOP.ATTRIBUTE3
, AHOP.ATTRIBUTE4
, AHOP.ATTRIBUTE5
, AHOP.ATTRIBUTE6
, AHOP.ATTRIBUTE7
, AHOP.ATTRIBUTE8
, AHOP.ATTRIBUTE9
, AHOP.ATTRIBUTE10
, AHOP.ATTRIBUTE11
, AHOP.ATTRIBUTE12
, AHOP.ATTRIBUTE13
, AHOP.ATTRIBUTE14
, AHOP.ATTRIBUTE15
FROM AHL_OPERATIONS_H_B AHOP
, AHL_OPERATIONS_H_TL AHOPTL
WHERE AHOP. OPERATIONS_H_ID = AHOPTL. OPERATIONS_H_ID
AND AHOPTL.LANGUAGE =USERENV('LANG')