VIEW: APPS.OZF_CHARGEBACK_INT

Source

View Text - Preformatted

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