VIEW: APPS.OZF_CHARGEBACK_HEADERS

Source

View Text - Preformatted

SELECT OCBHA.CHARGEBACK_HEADER_ID,OCBHA.OBJECT_VERSION_NUMBER,OCBHA.LAST_UPDATE_DATE,OCBHA.LAST_UPDATED_BY,OCBHA.CREATION_DATE,OCBHA.REQUEST_ID,OCBHA.CREATED_BY,OCBHA.LAST_UPDATE_LOGIN,OCBHA.PROGRAM_APPLICATION_ID,OCBHA.PROGRAM_UPDATE_DATE,OCBHA.PROGRAM_ID,OCBHA.BATCH_ID,OCBHA.CREATED_FROM,OCBHA.ORIG_SYSTEM_REFERENCE,OCBHA.DATE_SHIPPED,OCBHA.DATE_ORDERED,OCBHA.ORDER_TYPE_ID,OCBHA.ORDER_TYPE,OCBHA.ORDER_CATEGORY,OCBHA.STATUS_CODE,OCBHA.DIRECT_CUSTOMER_FLAG,OCBHA.ORDER_NUMBER,OCBHA.PRICE_LIST_ID,OCBHA.SOLD_FROM_CUST_ACCOUNT_ID,OCBHA.SHIP_FROM_CUST_ACCOUNT_ID,OCBHA.BILL_TO_CUST_ACCOUNT_ID,OCBHA.BILL_TO_ACCOUNT_NAME,OCBHA.BILL_TO_SITE_USE_ID,OCBHA.BILL_TO_LOCATION,OCBHA.SHIP_TO_CUST_ACCOUNT_ID,OCBHA.SHIP_TO_ACCOUNT_NAME,OCBHA.SHIP_TO_SITE_USE_ID,OCBHA.SHIP_TO_LOCATION,OCBHA.DATA_SOURCE_CODE,OCBHA.HEADER_ATTRIBUTE_CATEGORY,OCBHA.HEADER_ATTRIBUTE1,OCBHA.HEADER_ATTRIBUTE2,OCBHA.HEADER_ATTRIBUTE3,OCBHA.HEADER_ATTRIBUTE4,OCBHA.HEADER_ATTRIBUTE5,OCBHA.HEADER_ATTRIBUTE6,OCBHA.HEADER_ATTRIBUTE7,OCBHA.HEADER_ATTRIBUTE8,OCBHA.HEADER_ATTRIBUTE9,OCBHA.HEADER_ATTRIBUTE10,OCBHA.HEADER_ATTRIBUTE11,OCBHA.HEADER_ATTRIBUTE12,OCBHA.HEADER_ATTRIBUTE13,OCBHA.HEADER_ATTRIBUTE14,OCBHA.HEADER_ATTRIBUTE15,OCBHA.ATTRIBUTE_CATEGORY,OCBHA.ATTRIBUTE1,OCBHA.ATTRIBUTE2,OCBHA.ATTRIBUTE3,OCBHA.ATTRIBUTE4,OCBHA.ATTRIBUTE5,OCBHA.ATTRIBUTE6,OCBHA.ATTRIBUTE7,OCBHA.ATTRIBUTE8,OCBHA.ATTRIBUTE9,OCBHA.ATTRIBUTE10,OCBHA.ATTRIBUTE11,OCBHA.ATTRIBUTE12,OCBHA.ATTRIBUTE13,OCBHA.ATTRIBUTE14,OCBHA.ATTRIBUTE15,OCBHA.ORG_ID FROM OZF_CHARGEBACK_HEADERS_ALL OCBHA WHERE NVL(ORG_ID, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ' , NULL, SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ', NULL, SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT OCBHA.CHARGEBACK_HEADER_ID
, OCBHA.OBJECT_VERSION_NUMBER
, OCBHA.LAST_UPDATE_DATE
, OCBHA.LAST_UPDATED_BY
, OCBHA.CREATION_DATE
, OCBHA.REQUEST_ID
, OCBHA.CREATED_BY
, OCBHA.LAST_UPDATE_LOGIN
, OCBHA.PROGRAM_APPLICATION_ID
, OCBHA.PROGRAM_UPDATE_DATE
, OCBHA.PROGRAM_ID
, OCBHA.BATCH_ID
, OCBHA.CREATED_FROM
, OCBHA.ORIG_SYSTEM_REFERENCE
, OCBHA.DATE_SHIPPED
, OCBHA.DATE_ORDERED
, OCBHA.ORDER_TYPE_ID
, OCBHA.ORDER_TYPE
, OCBHA.ORDER_CATEGORY
, OCBHA.STATUS_CODE
, OCBHA.DIRECT_CUSTOMER_FLAG
, OCBHA.ORDER_NUMBER
, OCBHA.PRICE_LIST_ID
, OCBHA.SOLD_FROM_CUST_ACCOUNT_ID
, OCBHA.SHIP_FROM_CUST_ACCOUNT_ID
, OCBHA.BILL_TO_CUST_ACCOUNT_ID
, OCBHA.BILL_TO_ACCOUNT_NAME
, OCBHA.BILL_TO_SITE_USE_ID
, OCBHA.BILL_TO_LOCATION
, OCBHA.SHIP_TO_CUST_ACCOUNT_ID
, OCBHA.SHIP_TO_ACCOUNT_NAME
, OCBHA.SHIP_TO_SITE_USE_ID
, OCBHA.SHIP_TO_LOCATION
, OCBHA.DATA_SOURCE_CODE
, OCBHA.HEADER_ATTRIBUTE_CATEGORY
, OCBHA.HEADER_ATTRIBUTE1
, OCBHA.HEADER_ATTRIBUTE2
, OCBHA.HEADER_ATTRIBUTE3
, OCBHA.HEADER_ATTRIBUTE4
, OCBHA.HEADER_ATTRIBUTE5
, OCBHA.HEADER_ATTRIBUTE6
, OCBHA.HEADER_ATTRIBUTE7
, OCBHA.HEADER_ATTRIBUTE8
, OCBHA.HEADER_ATTRIBUTE9
, OCBHA.HEADER_ATTRIBUTE10
, OCBHA.HEADER_ATTRIBUTE11
, OCBHA.HEADER_ATTRIBUTE12
, OCBHA.HEADER_ATTRIBUTE13
, OCBHA.HEADER_ATTRIBUTE14
, OCBHA.HEADER_ATTRIBUTE15
, OCBHA.ATTRIBUTE_CATEGORY
, OCBHA.ATTRIBUTE1
, OCBHA.ATTRIBUTE2
, OCBHA.ATTRIBUTE3
, OCBHA.ATTRIBUTE4
, OCBHA.ATTRIBUTE5
, OCBHA.ATTRIBUTE6
, OCBHA.ATTRIBUTE7
, OCBHA.ATTRIBUTE8
, OCBHA.ATTRIBUTE9
, OCBHA.ATTRIBUTE10
, OCBHA.ATTRIBUTE11
, OCBHA.ATTRIBUTE12
, OCBHA.ATTRIBUTE13
, OCBHA.ATTRIBUTE14
, OCBHA.ATTRIBUTE15
, OCBHA.ORG_ID
FROM OZF_CHARGEBACK_HEADERS_ALL OCBHA
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)