VIEW: APPS.OZF_CHARGEBACK_LINES

Source

View Text - Preformatted

SELECT OCBLA.CHARGEBACK_LINE_ID,OCBLA.CHARGEBACK_HEADER_ID,OCBLA.OBJECT_VERSION_NUMBER,OCBLA.LAST_UPDATE_DATE,OCBLA.LAST_UPDATED_BY,OCBLA.CREATION_DATE,OCBLA.REQUEST_ID,OCBLA.CREATED_BY,OCBLA.LAST_UPDATE_LOGIN,OCBLA.PROGRAM_APPLICATION_ID,OCBLA.PROGRAM_UPDATE_DATE,OCBLA.PROGRAM_ID,OCBLA.BATCH_ID,OCBLA.CREATED_FROM,OCBLA.DATE_SHIPPED,OCBLA.DATE_ORDERED,OCBLA.PRICE_LIST_ID,OCBLA.SOLD_FROM_CUST_ACCOUNT_ID,OCBLA.SHIP_FROM_CUST_ACCOUNT_ID,OCBLA.ORIG_SYSTEM_QUANTITY,OCBLA.ORIG_SYSTEM_UOM,OCBLA.ORIG_SYSTEM_CURRENCY_CODE,OCBLA.ORIG_SYSTEM_SELLING_PRICE,OCBLA.BILL_TO_CUST_ACCOUNT_ID,OCBLA.BILL_TO_ACCOUNT_NAME,OCBLA.BILL_TO_SITE_USE_ID,OCBLA.BILL_TO_LOCATION,OCBLA.SHIP_TO_CUST_ACCOUNT_ID,OCBLA.SHIP_TO_ACCOUNT_NAME,OCBLA.SHIP_TO_SITE_USE_ID,OCBLA.SHIP_TO_LOCATION,OCBLA.ORIG_SYSTEM_LINE_REFERENCE,OCBLA.PRODUCT_CATEGORY_ID,OCBLA.CATEGORY_NAME,OCBLA.INVENTORY_ITEM_SEGMENT1,OCBLA.INVENTORY_ITEM_SEGMENT2,OCBLA.INVENTORY_ITEM_SEGMENT3,OCBLA.INVENTORY_ITEM_SEGMENT4,OCBLA.INVENTORY_ITEM_SEGMENT5,OCBLA.INVENTORY_ITEM_SEGMENT6,OCBLA.INVENTORY_ITEM_SEGMENT7,OCBLA.INVENTORY_ITEM_SEGMENT8,OCBLA.INVENTORY_ITEM_SEGMENT9,OCBLA.INVENTORY_ITEM_SEGMENT10,OCBLA.INVENTORY_ITEM_SEGMENT11,OCBLA.INVENTORY_ITEM_SEGMENT12,OCBLA.INVENTORY_ITEM_SEGMENT13,OCBLA.INVENTORY_ITEM_SEGMENT14,OCBLA.INVENTORY_ITEM_SEGMENT15,OCBLA.INVENTORY_ITEM_SEGMENT16,OCBLA.INVENTORY_ITEM_SEGMENT17,OCBLA.INVENTORY_ITEM_SEGMENT18,OCBLA.INVENTORY_ITEM_SEGMENT19,OCBLA.INVENTORY_ITEM_SEGMENT20,OCBLA.INVENTORY_ITEM_ID,OCBLA.QUANTITY,OCBLA.UOM,OCBLA.CURRENCY_CODE,OCBLA.SELLING_PRICE,OCBLA.ADJUSTED_PRICE,OCBLA.PRICED_UOM,OCBLA.PRICED_QUANTITY,OCBLA.EXCHANGE_RATE_TYPE,OCBLA.EXCHANGE_RATE,OCBLA.EXCHANGE_DATE,OCBLA.ACCTD_ADJUSTED_PRICE,OCBLA.STATUS_CODE,OCBLA.DATA_SOURCE_CODE,OCBLA.LINE_ATTRIBUTE_CATEGORY,OCBLA.LINE_ATTRIBUTE1,OCBLA.LINE_ATTRIBUTE2,OCBLA.LINE_ATTRIBUTE3,OCBLA.LINE_ATTRIBUTE4,OCBLA.LINE_ATTRIBUTE5,OCBLA.LINE_ATTRIBUTE6,OCBLA.LINE_ATTRIBUTE7,OCBLA.LINE_ATTRIBUTE8,OCBLA.LINE_ATTRIBUTE9,OCBLA.LINE_ATTRIBUTE10,OCBLA.LINE_ATTRIBUTE11,OCBLA.LINE_ATTRIBUTE12,OCBLA.LINE_ATTRIBUTE13,OCBLA.LINE_ATTRIBUTE14,OCBLA.LINE_ATTRIBUTE15,OCBLA.ATTRIBUTE_CATEGORY,OCBLA.ATTRIBUTE1,OCBLA.ATTRIBUTE2,OCBLA.ATTRIBUTE3,OCBLA.ATTRIBUTE4,OCBLA.ATTRIBUTE5,OCBLA.ATTRIBUTE6,OCBLA.ATTRIBUTE7,OCBLA.ATTRIBUTE9,OCBLA.ATTRIBUTE8,OCBLA.ATTRIBUTE11,OCBLA.ATTRIBUTE10,OCBLA.ATTRIBUTE12,OCBLA.ATTRIBUTE13,OCBLA.ATTRIBUTE14,OCBLA.ATTRIBUTE15,OCBLA.ORG_ID FROM OZF_CHARGEBACK_LINES_ALL OCBLA 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 OCBLA.CHARGEBACK_LINE_ID
, OCBLA.CHARGEBACK_HEADER_ID
, OCBLA.OBJECT_VERSION_NUMBER
, OCBLA.LAST_UPDATE_DATE
, OCBLA.LAST_UPDATED_BY
, OCBLA.CREATION_DATE
, OCBLA.REQUEST_ID
, OCBLA.CREATED_BY
, OCBLA.LAST_UPDATE_LOGIN
, OCBLA.PROGRAM_APPLICATION_ID
, OCBLA.PROGRAM_UPDATE_DATE
, OCBLA.PROGRAM_ID
, OCBLA.BATCH_ID
, OCBLA.CREATED_FROM
, OCBLA.DATE_SHIPPED
, OCBLA.DATE_ORDERED
, OCBLA.PRICE_LIST_ID
, OCBLA.SOLD_FROM_CUST_ACCOUNT_ID
, OCBLA.SHIP_FROM_CUST_ACCOUNT_ID
, OCBLA.ORIG_SYSTEM_QUANTITY
, OCBLA.ORIG_SYSTEM_UOM
, OCBLA.ORIG_SYSTEM_CURRENCY_CODE
, OCBLA.ORIG_SYSTEM_SELLING_PRICE
, OCBLA.BILL_TO_CUST_ACCOUNT_ID
, OCBLA.BILL_TO_ACCOUNT_NAME
, OCBLA.BILL_TO_SITE_USE_ID
, OCBLA.BILL_TO_LOCATION
, OCBLA.SHIP_TO_CUST_ACCOUNT_ID
, OCBLA.SHIP_TO_ACCOUNT_NAME
, OCBLA.SHIP_TO_SITE_USE_ID
, OCBLA.SHIP_TO_LOCATION
, OCBLA.ORIG_SYSTEM_LINE_REFERENCE
, OCBLA.PRODUCT_CATEGORY_ID
, OCBLA.CATEGORY_NAME
, OCBLA.INVENTORY_ITEM_SEGMENT1
, OCBLA.INVENTORY_ITEM_SEGMENT2
, OCBLA.INVENTORY_ITEM_SEGMENT3
, OCBLA.INVENTORY_ITEM_SEGMENT4
, OCBLA.INVENTORY_ITEM_SEGMENT5
, OCBLA.INVENTORY_ITEM_SEGMENT6
, OCBLA.INVENTORY_ITEM_SEGMENT7
, OCBLA.INVENTORY_ITEM_SEGMENT8
, OCBLA.INVENTORY_ITEM_SEGMENT9
, OCBLA.INVENTORY_ITEM_SEGMENT10
, OCBLA.INVENTORY_ITEM_SEGMENT11
, OCBLA.INVENTORY_ITEM_SEGMENT12
, OCBLA.INVENTORY_ITEM_SEGMENT13
, OCBLA.INVENTORY_ITEM_SEGMENT14
, OCBLA.INVENTORY_ITEM_SEGMENT15
, OCBLA.INVENTORY_ITEM_SEGMENT16
, OCBLA.INVENTORY_ITEM_SEGMENT17
, OCBLA.INVENTORY_ITEM_SEGMENT18
, OCBLA.INVENTORY_ITEM_SEGMENT19
, OCBLA.INVENTORY_ITEM_SEGMENT20
, OCBLA.INVENTORY_ITEM_ID
, OCBLA.QUANTITY
, OCBLA.UOM
, OCBLA.CURRENCY_CODE
, OCBLA.SELLING_PRICE
, OCBLA.ADJUSTED_PRICE
, OCBLA.PRICED_UOM
, OCBLA.PRICED_QUANTITY
, OCBLA.EXCHANGE_RATE_TYPE
, OCBLA.EXCHANGE_RATE
, OCBLA.EXCHANGE_DATE
, OCBLA.ACCTD_ADJUSTED_PRICE
, OCBLA.STATUS_CODE
, OCBLA.DATA_SOURCE_CODE
, OCBLA.LINE_ATTRIBUTE_CATEGORY
, OCBLA.LINE_ATTRIBUTE1
, OCBLA.LINE_ATTRIBUTE2
, OCBLA.LINE_ATTRIBUTE3
, OCBLA.LINE_ATTRIBUTE4
, OCBLA.LINE_ATTRIBUTE5
, OCBLA.LINE_ATTRIBUTE6
, OCBLA.LINE_ATTRIBUTE7
, OCBLA.LINE_ATTRIBUTE8
, OCBLA.LINE_ATTRIBUTE9
, OCBLA.LINE_ATTRIBUTE10
, OCBLA.LINE_ATTRIBUTE11
, OCBLA.LINE_ATTRIBUTE12
, OCBLA.LINE_ATTRIBUTE13
, OCBLA.LINE_ATTRIBUTE14
, OCBLA.LINE_ATTRIBUTE15
, OCBLA.ATTRIBUTE_CATEGORY
, OCBLA.ATTRIBUTE1
, OCBLA.ATTRIBUTE2
, OCBLA.ATTRIBUTE3
, OCBLA.ATTRIBUTE4
, OCBLA.ATTRIBUTE5
, OCBLA.ATTRIBUTE6
, OCBLA.ATTRIBUTE7
, OCBLA.ATTRIBUTE9
, OCBLA.ATTRIBUTE8
, OCBLA.ATTRIBUTE11
, OCBLA.ATTRIBUTE10
, OCBLA.ATTRIBUTE12
, OCBLA.ATTRIBUTE13
, OCBLA.ATTRIBUTE14
, OCBLA.ATTRIBUTE15
, OCBLA.ORG_ID
FROM OZF_CHARGEBACK_LINES_ALL OCBLA
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)