VIEW: APPS.OZF_CHARGEBACK_PRICE_ADJ

Source

View Text - Preformatted

SELECT RESALE_ADJUSTMENT_ID , RESALE_LINE_ID , OBJECT_VERSION_NUMBER , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , REQUEST_ID , CREATED_BY , LAST_UPDATE_LOGIN , PROGRAM_APPLICATION_ID , PROGRAM_UPDATE_DATE , PROGRAM_ID , RESALE_BATCH_ID , CREATED_FROM , LIST_HEADER_ID , LIST_LINE_ID , ACCEPTED_AMOUNT , AGREEMENT_UOM_CODE , PRICED_QUANTITY , OPERAND , OPERAND_CALCULATION_CODE , NULL , ORG_ID , SECURITY_GROUP_ID FROM OZF_RESALE_ADJUSTMENTS_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_ADJUSTMENT_ID
, RESALE_LINE_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, REQUEST_ID
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_ID
, RESALE_BATCH_ID
, CREATED_FROM
, LIST_HEADER_ID
, LIST_LINE_ID
, ACCEPTED_AMOUNT
, AGREEMENT_UOM_CODE
, PRICED_QUANTITY
, OPERAND
, OPERAND_CALCULATION_CODE
, NULL
, ORG_ID
, SECURITY_GROUP_ID
FROM OZF_RESALE_ADJUSTMENTS_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)