View: OE_SYS_PARAMS_ALL_UPG

Product:	ONT - Order Management
Description:	This view shows all the Parameter Values in OE_SYS_PARAMETERS_ALL table.
Implementation/DBA Data:	APPS.OE_SYS_PARAMS_ALL_UPG

View Text

SELECT SP.ROWID
, SP.ORG_ID
, SP.CREATION_DATE
, SP.CREATED_BY
, SP.LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY
, SP.LAST_UPDATE_LOGIN
, TO_NUMBER(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
, SP.ORG_ID)) MASTER_ORGANIZATION_ID
, OE_SYS_PARAMETERS.VALUE('CUSTOMER_RELATIONSHIPS_FLAG'
, SP.ORG_ID) CUSTOMER_RELATIONSHIPS_FLAG
, OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG'
, SP.ORG_ID) AUDIT_TRAIL_ENABLE_FLAG
, OE_SYS_PARAMETERS.VALUE('COMPUTE_MARGIN_FLAG'
, SP.ORG_ID) COMPUTE_MARGIN_FLAG
, OE_SYS_PARAMETERS.VALUE('FREIGHT_RATING_ENABLED_FLAG'
, SP.ORG_ID) FREIGHT_RATING_ENABLED_FLAG
, OE_SYS_PARAMETERS.VALUE('FTE_SHIP_METHOD_ENABLED_FLAG'
, SP.ORG_ID) FTE_SHIP_METHOD_ENABLED_FLAG
, SP.CONTEXT
, SP.ATTRIBUTE1
, SP.ATTRIBUTE2
, SP.ATTRIBUTE3
, SP.ATTRIBUTE4
, SP.ATTRIBUTE5
, SP.ATTRIBUTE6
, SP.ATTRIBUTE7
, SP.ATTRIBUTE8
, SP.ATTRIBUTE9
, SP.ATTRIBUTE10
, SP.ATTRIBUTE11
, SP.ATTRIBUTE12
, SP.ATTRIBUTE13
, SP.ATTRIBUTE14
, SP.ATTRIBUTE15
FROM OE_SYS_PARAMETERS_ALL SP
WHERE SP.PARAMETER_CODE = 'MASTER_ORGANIZATION_ID'

Columns