VIEW: APPS.CS_REPAIRS

Source

View Text - Preformatted

SELECT REPAIR_LINE_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , REQUEST_ID , REPAIR_NUMBER , PROGRAM_ID , PROGRAM_APPLICATION_ID , PROGRAM_UPDATE_DATE , RMA_HEADER_ID , RMA_LINE_ID , RMA_CUSTOMER_ID , RMA_NUMBER , RMA_TYPE_ID , RMA_DATE , RMA_LINE_NUMBER , REPAIR_DURATION , RECEIVED_DATE ,MTL_TRANSACTION_ID , SHIPPED_DATE , ESTIMATE_ID , WIP_ENTITY_ID , GROUP_ID , REPAIR_HEADER_ID , REPAIR_ORDER_LINE_ID , REPLACE_HEADER_ID , LOANER_HEADER_ID , CUSTOMER_PRODUCT_ID , INVENTORY_ITEM_ID , SERIAL_NUMBER , QUANTITY_RECEIVED , QUANTITY_COMPLETE , QUANTITY_SCRAPPED , QUANTITY_REPLACED , REPAIR_UNIT_OF_MEASURE_CODE , STATUS , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , CONTEXT , ORG_ID , ORGANIZATION_ID , RECVD_ORGANIZATION_ID , ORIGINAL_SYSTEM_REFERENCE , ORIGINAL_SYSTEM_LINE_REFERENCE , ALLOW_JOB , INCIDENT_ID , ESTIMATE_BUSINESS_GROUP_ID , DIAGNOSIS_ID , DIAGNOSED_BY_ID , JOB_COMPLETION_DATE , PROMISED_DELIVERY_DATE , PROJECT_ID , TASK_ID FROM CS_REPAIRS_ALL WHERE NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT REPAIR_LINE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, REPAIR_NUMBER
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, RMA_HEADER_ID
, RMA_LINE_ID
, RMA_CUSTOMER_ID
, RMA_NUMBER
, RMA_TYPE_ID
, RMA_DATE
, RMA_LINE_NUMBER
, REPAIR_DURATION
, RECEIVED_DATE
, MTL_TRANSACTION_ID
, SHIPPED_DATE
, ESTIMATE_ID
, WIP_ENTITY_ID
, GROUP_ID
, REPAIR_HEADER_ID
, REPAIR_ORDER_LINE_ID
, REPLACE_HEADER_ID
, LOANER_HEADER_ID
, CUSTOMER_PRODUCT_ID
, INVENTORY_ITEM_ID
, SERIAL_NUMBER
, QUANTITY_RECEIVED
, QUANTITY_COMPLETE
, QUANTITY_SCRAPPED
, QUANTITY_REPLACED
, REPAIR_UNIT_OF_MEASURE_CODE
, STATUS
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, ORG_ID
, ORGANIZATION_ID
, RECVD_ORGANIZATION_ID
, ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE
, ALLOW_JOB
, INCIDENT_ID
, ESTIMATE_BUSINESS_GROUP_ID
, DIAGNOSIS_ID
, DIAGNOSED_BY_ID
, JOB_COMPLETION_DATE
, PROMISED_DELIVERY_DATE
, PROJECT_ID
, TASK_ID
FROM CS_REPAIRS_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)