VIEW: APPS.OZF_CHARGEBACK_INT

Source

View Text - Preformatted

SELECT OCBIA.CHARGEBACK_INT_ID,OCBIA.OBJECT_VERSION_NUMBER,OCBIA.LAST_UPDATE_DATE,OCBIA.LAST_UPDATED_BY,OCBIA.CREATION_DATE,OCBIA.REQUEST_ID,OCBIA.CREATED_BY,OCBIA.CREATED_FROM,OCBIA.LAST_UPDATE_LOGIN,OCBIA.PROGRAM_APPLICATION_ID,OCBIA.PROGRAM_UPDATE_DATE,OCBIA.PROGRAM_ID,OCBIA.BATCH_ID,OCBIA.ORIG_SYSTEM_REFERENCE,OCBIA.DATE_SHIPPED,OCBIA.DATE_ORDERED,OCBIA.ORDER_TYPE_ID,OCBIA.ORDER_TYPE,OCBIA.ORDER_CATEGORY,OCBIA.STATUS_CODE,OCBIA.DIRECT_CUSTOMER_FLAG,OCBIA.ORDER_NUMBER,OCBIA.PRICE_LIST_ID,OCBIA.PRICE_LIST_NAME,OCBIA.SOLD_FROM_CUST_ACCOUNT_ID,OCBIA.SOLD_FROM_ACCOUNT_NAME,OCBIA.SHIP_FROM_CUST_ACCOUNT_ID,OCBIA.SHIP_FROM_ACCOUNT_NAME,OCBIA.ORIG_SYSTEM_UOM,OCBIA.ORIG_SYSTEM_QUANTITY,OCBIA.ORIG_SYSTEM_CURRENCY_CODE,OCBIA.ORIG_SYSTEM_SELLING_PRICE,OCBIA.BILL_TO_CUST_ACCOUNT_ID,OCBIA.BILL_TO_ACCOUNT_NAME,OCBIA.BILL_TO_SITE_USE_ID,OCBIA.BILL_TO_LOCATION,OCBIA.SHIP_TO_CUST_ACCOUNT_ID,OCBIA.SHIP_TO_ACCOUNT_NAME,OCBIA.SHIP_TO_SITE_USE_ID,OCBIA.SHIP_TO_LOCATION,OCBIA.ORIG_SYSTEM_LINE_REFERENCE,OCBIA.PRODUCT_CATEGORY_ID,OCBIA.CATEGORY_NAME,OCBIA.INVENTORY_ITEM_SEGMENT1,OCBIA.INVENTORY_ITEM_SEGMENT2,OCBIA.INVENTORY_ITEM_SEGMENT3,OCBIA.INVENTORY_ITEM_SEGMENT4,OCBIA.INVENTORY_ITEM_SEGMENT5,OCBIA.INVENTORY_ITEM_SEGMENT6,OCBIA.INVENTORY_ITEM_SEGMENT7,OCBIA.INVENTORY_ITEM_SEGMENT8,OCBIA.INVENTORY_ITEM_SEGMENT9,OCBIA.INVENTORY_ITEM_SEGMENT10,OCBIA.INVENTORY_ITEM_SEGMENT11,OCBIA.INVENTORY_ITEM_SEGMENT12,OCBIA.INVENTORY_ITEM_SEGMENT13,OCBIA.INVENTORY_ITEM_SEGMENT14,OCBIA.INVENTORY_ITEM_SEGMENT15,OCBIA.INVENTORY_ITEM_SEGMENT16,OCBIA.INVENTORY_ITEM_SEGMENT17,OCBIA.INVENTORY_ITEM_SEGMENT18,OCBIA.INVENTORY_ITEM_SEGMENT19,OCBIA.INVENTORY_ITEM_SEGMENT20,OCBIA.INVENTORY_ITEM_ID,OCBIA.QUANTITY,OCBIA.UOM,OCBIA.CURRENCY_CODE,OCBIA.EXCHANGE_RATE,OCBIA.EXCHANGE_RATE_TYPE,OCBIA.EXCHANGE_DATE,OCBIA.SELLING_PRICE,OCBIA.HEADER_ATTRIBUTE_CATEGORY,OCBIA.HEADER_ATTRIBUTE1,OCBIA.HEADER_ATTRIBUTE2,OCBIA.HEADER_ATTRIBUTE3,OCBIA.HEADER_ATTRIBUTE4,OCBIA.HEADER_ATTRIBUTE5,OCBIA.HEADER_ATTRIBUTE6,OCBIA.HEADER_ATTRIBUTE7,OCBIA.HEADER_ATTRIBUTE8,OCBIA.HEADER_ATTRIBUTE9,OCBIA.HEADER_ATTRIBUTE10,OCBIA.HEADER_ATTRIBUTE11,OCBIA.HEADER_ATTRIBUTE12,OCBIA.HEADER_ATTRIBUTE13,OCBIA.HEADER_ATTRIBUTE14,OCBIA.HEADER_ATTRIBUTE15,OCBIA.LINE_ATTRIBUTE_CATEGORY,OCBIA.LINE_ATTRIBUTE1,OCBIA.LINE_ATTRIBUTE2,OCBIA.LINE_ATTRIBUTE3,OCBIA.LINE_ATTRIBUTE4,OCBIA.LINE_ATTRIBUTE5,OCBIA.LINE_ATTRIBUTE6,OCBIA.LINE_ATTRIBUTE7,OCBIA.LINE_ATTRIBUTE8,OCBIA.LINE_ATTRIBUTE9,OCBIA.LINE_ATTRIBUTE10,OCBIA.LINE_ATTRIBUTE11,OCBIA.LINE_ATTRIBUTE12,OCBIA.LINE_ATTRIBUTE13,OCBIA.LINE_ATTRIBUTE14,OCBIA.LINE_ATTRIBUTE15,OCBIA.ORG_ID,OCBIA.DATA_SOURCE_CODE FROM OZF_CHARGEBACK_INT_ALL OCBIA 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 OCBIA.CHARGEBACK_INT_ID
, OCBIA.OBJECT_VERSION_NUMBER
, OCBIA.LAST_UPDATE_DATE
, OCBIA.LAST_UPDATED_BY
, OCBIA.CREATION_DATE
, OCBIA.REQUEST_ID
, OCBIA.CREATED_BY
, OCBIA.CREATED_FROM
, OCBIA.LAST_UPDATE_LOGIN
, OCBIA.PROGRAM_APPLICATION_ID
, OCBIA.PROGRAM_UPDATE_DATE
, OCBIA.PROGRAM_ID
, OCBIA.BATCH_ID
, OCBIA.ORIG_SYSTEM_REFERENCE
, OCBIA.DATE_SHIPPED
, OCBIA.DATE_ORDERED
, OCBIA.ORDER_TYPE_ID
, OCBIA.ORDER_TYPE
, OCBIA.ORDER_CATEGORY
, OCBIA.STATUS_CODE
, OCBIA.DIRECT_CUSTOMER_FLAG
, OCBIA.ORDER_NUMBER
, OCBIA.PRICE_LIST_ID
, OCBIA.PRICE_LIST_NAME
, OCBIA.SOLD_FROM_CUST_ACCOUNT_ID
, OCBIA.SOLD_FROM_ACCOUNT_NAME
, OCBIA.SHIP_FROM_CUST_ACCOUNT_ID
, OCBIA.SHIP_FROM_ACCOUNT_NAME
, OCBIA.ORIG_SYSTEM_UOM
, OCBIA.ORIG_SYSTEM_QUANTITY
, OCBIA.ORIG_SYSTEM_CURRENCY_CODE
, OCBIA.ORIG_SYSTEM_SELLING_PRICE
, OCBIA.BILL_TO_CUST_ACCOUNT_ID
, OCBIA.BILL_TO_ACCOUNT_NAME
, OCBIA.BILL_TO_SITE_USE_ID
, OCBIA.BILL_TO_LOCATION
, OCBIA.SHIP_TO_CUST_ACCOUNT_ID
, OCBIA.SHIP_TO_ACCOUNT_NAME
, OCBIA.SHIP_TO_SITE_USE_ID
, OCBIA.SHIP_TO_LOCATION
, OCBIA.ORIG_SYSTEM_LINE_REFERENCE
, OCBIA.PRODUCT_CATEGORY_ID
, OCBIA.CATEGORY_NAME
, OCBIA.INVENTORY_ITEM_SEGMENT1
, OCBIA.INVENTORY_ITEM_SEGMENT2
, OCBIA.INVENTORY_ITEM_SEGMENT3
, OCBIA.INVENTORY_ITEM_SEGMENT4
, OCBIA.INVENTORY_ITEM_SEGMENT5
, OCBIA.INVENTORY_ITEM_SEGMENT6
, OCBIA.INVENTORY_ITEM_SEGMENT7
, OCBIA.INVENTORY_ITEM_SEGMENT8
, OCBIA.INVENTORY_ITEM_SEGMENT9
, OCBIA.INVENTORY_ITEM_SEGMENT10
, OCBIA.INVENTORY_ITEM_SEGMENT11
, OCBIA.INVENTORY_ITEM_SEGMENT12
, OCBIA.INVENTORY_ITEM_SEGMENT13
, OCBIA.INVENTORY_ITEM_SEGMENT14
, OCBIA.INVENTORY_ITEM_SEGMENT15
, OCBIA.INVENTORY_ITEM_SEGMENT16
, OCBIA.INVENTORY_ITEM_SEGMENT17
, OCBIA.INVENTORY_ITEM_SEGMENT18
, OCBIA.INVENTORY_ITEM_SEGMENT19
, OCBIA.INVENTORY_ITEM_SEGMENT20
, OCBIA.INVENTORY_ITEM_ID
, OCBIA.QUANTITY
, OCBIA.UOM
, OCBIA.CURRENCY_CODE
, OCBIA.EXCHANGE_RATE
, OCBIA.EXCHANGE_RATE_TYPE
, OCBIA.EXCHANGE_DATE
, OCBIA.SELLING_PRICE
, OCBIA.HEADER_ATTRIBUTE_CATEGORY
, OCBIA.HEADER_ATTRIBUTE1
, OCBIA.HEADER_ATTRIBUTE2
, OCBIA.HEADER_ATTRIBUTE3
, OCBIA.HEADER_ATTRIBUTE4
, OCBIA.HEADER_ATTRIBUTE5
, OCBIA.HEADER_ATTRIBUTE6
, OCBIA.HEADER_ATTRIBUTE7
, OCBIA.HEADER_ATTRIBUTE8
, OCBIA.HEADER_ATTRIBUTE9
, OCBIA.HEADER_ATTRIBUTE10
, OCBIA.HEADER_ATTRIBUTE11
, OCBIA.HEADER_ATTRIBUTE12
, OCBIA.HEADER_ATTRIBUTE13
, OCBIA.HEADER_ATTRIBUTE14
, OCBIA.HEADER_ATTRIBUTE15
, OCBIA.LINE_ATTRIBUTE_CATEGORY
, OCBIA.LINE_ATTRIBUTE1
, OCBIA.LINE_ATTRIBUTE2
, OCBIA.LINE_ATTRIBUTE3
, OCBIA.LINE_ATTRIBUTE4
, OCBIA.LINE_ATTRIBUTE5
, OCBIA.LINE_ATTRIBUTE6
, OCBIA.LINE_ATTRIBUTE7
, OCBIA.LINE_ATTRIBUTE8
, OCBIA.LINE_ATTRIBUTE9
, OCBIA.LINE_ATTRIBUTE10
, OCBIA.LINE_ATTRIBUTE11
, OCBIA.LINE_ATTRIBUTE12
, OCBIA.LINE_ATTRIBUTE13
, OCBIA.LINE_ATTRIBUTE14
, OCBIA.LINE_ATTRIBUTE15
, OCBIA.ORG_ID
, OCBIA.DATA_SOURCE_CODE
FROM OZF_CHARGEBACK_INT_ALL OCBIA
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)