VIEW: OZF.OZF_CHARGEBACK_INT_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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