VIEW: APPS.AHL_ROUTES_B_KFV

Source

View Text - Preformatted

SELECT ROWID, ROUTE_ID, OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ROUTE_NO, REVISION_NUMBER, REVISION_STATUS_CODE, SUMMARY_FLAG, ENABLED_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE, OPERATOR_PARTY_ID, SERVICE_ITEM_ID, SERVICE_ITEM_ORG_ID, TASK_TEMPLATE_GROUP_ID, ACCOUNTING_CLASS_CODE, ACCOUNTING_CLASS_ORG_ID, ROUTE_TYPE_CODE, PRODUCT_TYPE_CODE, ZONE_CODE, SUB_ZONE_CODE, PROCESS_CODE, APPLICATION_USG_CODE, TIME_SPAN, QA_INSPECTION_TYPE, SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, SEGMENT7, SEGMENT8, SEGMENT9, SEGMENT10, SEGMENT11, SEGMENT12, SEGMENT13, SEGMENT14, SEGMENT15, 'X', 'X', ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, UNIT_RECEIPT_UPDATE_FLAG, ENIGMA_PUBLISH_DATE, ENIGMA_ROUTE_ID, ENIGMA_DOC_ID, FILE_ID, MODEL_CODE FROM AHL_ROUTES_B

View Text - HTML Formatted

SELECT ROWID
, ROUTE_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ROUTE_NO
, REVISION_NUMBER
, REVISION_STATUS_CODE
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OPERATOR_PARTY_ID
, SERVICE_ITEM_ID
, SERVICE_ITEM_ORG_ID
, TASK_TEMPLATE_GROUP_ID
, ACCOUNTING_CLASS_CODE
, ACCOUNTING_CLASS_ORG_ID
, ROUTE_TYPE_CODE
, PRODUCT_TYPE_CODE
, ZONE_CODE
, SUB_ZONE_CODE
, PROCESS_CODE
, APPLICATION_USG_CODE
, TIME_SPAN
, QA_INSPECTION_TYPE
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, 'X'
, 'X'
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, UNIT_RECEIPT_UPDATE_FLAG
, ENIGMA_PUBLISH_DATE
, ENIGMA_ROUTE_ID
, ENIGMA_DOC_ID
, FILE_ID
, MODEL_CODE
FROM AHL_ROUTES_B