VIEW: APPS.OZF_CHARGEBACK_PRICE_ADJ

Source

View Text - Preformatted

SELECT OCPAJ.CHARGEBACK_PRICE_ADJ_ID,OCPAJ.CHARGEBACK_LINE_ID,OCPAJ.OBJECT_VERSION_NUMBER,OCPAJ.LAST_UPDATE_DATE,OCPAJ.LAST_UPDATED_BY,OCPAJ.CREATION_DATE,OCPAJ.REQUEST_ID,OCPAJ.CREATED_BY,OCPAJ.LAST_UPDATE_LOGIN,OCPAJ.PROGRAM_APPLICATION_ID,OCPAJ.PROGRAM_UPDATE_DATE,OCPAJ.PROGRAM_ID,OCPAJ.BATCH_ID,OCPAJ.CREATED_FROM,OCPAJ.LIST_HEADER_ID,OCPAJ.LIST_LINE_ID,OCPAJ.ADJUSTED_UNIT_AMOUNT,OCPAJ.PRICED_UOM,OCPAJ.PRICED_QUANTITY,OCPAJ.OPERAND,OCPAJ.OPERAND_CALCULATION_CODE,OCPAJ.ACCRUAL_FLAG,OCPAJ.ORG_ID,OCPAJ.SECURITY_GROUP_ID FROM OZF_CHARGEBACK_PRICE_ADJ_ALL OCPAJ 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 OCPAJ.CHARGEBACK_PRICE_ADJ_ID
, OCPAJ.CHARGEBACK_LINE_ID
, OCPAJ.OBJECT_VERSION_NUMBER
, OCPAJ.LAST_UPDATE_DATE
, OCPAJ.LAST_UPDATED_BY
, OCPAJ.CREATION_DATE
, OCPAJ.REQUEST_ID
, OCPAJ.CREATED_BY
, OCPAJ.LAST_UPDATE_LOGIN
, OCPAJ.PROGRAM_APPLICATION_ID
, OCPAJ.PROGRAM_UPDATE_DATE
, OCPAJ.PROGRAM_ID
, OCPAJ.BATCH_ID
, OCPAJ.CREATED_FROM
, OCPAJ.LIST_HEADER_ID
, OCPAJ.LIST_LINE_ID
, OCPAJ.ADJUSTED_UNIT_AMOUNT
, OCPAJ.PRICED_UOM
, OCPAJ.PRICED_QUANTITY
, OCPAJ.OPERAND
, OCPAJ.OPERAND_CALCULATION_CODE
, OCPAJ.ACCRUAL_FLAG
, OCPAJ.ORG_ID
, OCPAJ.SECURITY_GROUP_ID
FROM OZF_CHARGEBACK_PRICE_ADJ_ALL OCPAJ
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)