Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: QP.QP_INTERFACE_PRICING_ATTRIBS#

Object Details
Object Name: QP_INTERFACE_PRICING_ATTRIBS#
Object Type: VIEW
Owner: QP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PRICING_ATTRIBUTE_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

LIST_LINE_ID NUMBER

EXCLUDER_FLAG VARCHAR2 (1)
ACCUMULATE_FLAG VARCHAR2 (1)
PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2 (30)
PRODUCT_ATTRIBUTE VARCHAR2 (30)
PRODUCT_ATTR_VALUE VARCHAR2 (240)
PRODUCT_UOM_CODE VARCHAR2 (3)
PRICING_ATTRIBUTE_CONTEXT VARCHAR2 (30)
PRICING_ATTRIBUTE VARCHAR2 (30)
PRICING_ATTR_VALUE_FROM VARCHAR2 (240)
PRICING_ATTR_VALUE_TO VARCHAR2 (240)
ATTRIBUTE_GROUPING_NO NUMBER

PRODUCT_ATTRIBUTE_DATATYPE VARCHAR2 (30)
PRICING_ATTRIBUTE_DATATYPE VARCHAR2 (30)
COMPARISON_OPERATOR_CODE VARCHAR2 (30)
LIST_HEADER_ID NUMBER

PRICING_PHASE_ID NUMBER

QUALIFICATION_IND NUMBER

PRICING_ATTR_VALUE_FROM_NUMBER NUMBER

PRICING_ATTR_VALUE_TO_NUMBER NUMBER

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
PROCESS_ID NUMBER

PROCESS_TYPE VARCHAR2 (30)
INTERFACE_ACTION_CODE VARCHAR2 (30)
LOCK_FLAG VARCHAR2 (2)
PROCESS_FLAG VARCHAR2 (2)
DELETE_FLAG VARCHAR2 (2)
PROCESS_STATUS_FLAG VARCHAR2 (2)
PRICE_LIST_LINE_INDEX NUMBER

LIST_LINE_NO VARCHAR2 (30)
PRODUCT_ATTR_CODE VARCHAR2 (50)
PRODUCT_ATTR_VAL_DISP VARCHAR2 (50)
PRICING_ATTR_CODE VARCHAR2 (50)
PRICING_ATTR_VALUE_FROM_DISP VARCHAR2 (50)
PRICING_ATTR_VALUE_TO_DISP VARCHAR2 (50)
ATTRIBUTE_STATUS VARCHAR2 (50)
ORIG_SYS_LINE_REF VARCHAR2 (50)
ORIG_SYS_PRICING_ATTR_REF VARCHAR2 (50)
ORIG_SYS_HEADER_REF VARCHAR2 (50)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PRICING_ATTRIBUTE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LIST_LINE_ID
,      EXCLUDER_FLAG
,      ACCUMULATE_FLAG
,      PRODUCT_ATTRIBUTE_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      PRODUCT_UOM_CODE
,      PRICING_ATTRIBUTE_CONTEXT
,      PRICING_ATTRIBUTE
,      PRICING_ATTR_VALUE_FROM
,      PRICING_ATTR_VALUE_TO
,      ATTRIBUTE_GROUPING_NO
,      PRODUCT_ATTRIBUTE_DATATYPE
,      PRICING_ATTRIBUTE_DATATYPE
,      COMPARISON_OPERATOR_CODE
,      LIST_HEADER_ID
,      PRICING_PHASE_ID
,      QUALIFICATION_IND
,      PRICING_ATTR_VALUE_FROM_NUMBER
,      PRICING_ATTR_VALUE_TO_NUMBER
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROCESS_ID
,      PROCESS_TYPE
,      INTERFACE_ACTION_CODE
,      LOCK_FLAG
,      PROCESS_FLAG
,      DELETE_FLAG
,      PROCESS_STATUS_FLAG
,      PRICE_LIST_LINE_INDEX
,      LIST_LINE_NO
,      PRODUCT_ATTR_CODE
,      PRODUCT_ATTR_VAL_DISP
,      PRICING_ATTR_CODE
,      PRICING_ATTR_VALUE_FROM_DISP
,      PRICING_ATTR_VALUE_TO_DISP
,      ATTRIBUTE_STATUS
,      ORIG_SYS_LINE_REF
,      ORIG_SYS_PRICING_ATTR_REF
,      ORIG_SYS_HEADER_REF
FROM QP.QP_INTERFACE_PRICING_ATTRIBS#;

Dependencies

[top of page]

QP.QP_INTERFACE_PRICING_ATTRIBS# references the following:

SchemaQP
TableQP_INTERFACE_PRICING_ATTRIBS
QP.QP_INTERFACE_PRICING_ATTRIBS# is referenced by following:

SchemaAPPS
SynonymQP_INTERFACE_PRICING_ATTRIBS