[Home] [Help] [Dependency Information]
Object Name: | QPR_PN_INT_LINES# |
---|---|
Object Type: | VIEW |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PN_INT_LINE_ID | NUMBER | Yes | ||
SOURCE_ID | NUMBER | |||
SOURCE_REF_HDR_ID | NUMBER | |||
SOURCE_REF_LINE_ID | NUMBER | |||
SOURCE_REQUEST_LINE_NUMBER | VARCHAR2 | (30) | ||
PRICE_PLAN_ID | NUMBER | |||
ORG_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
GEOGRAPHY_ID | NUMBER | |||
PAYMENT_TERM_ID | NUMBER | |||
PR_SEGMENT_ID | NUMBER | |||
VOL_BAND_SK | VARCHAR2 | (240) | ||
TOP_MDL_SRC_LINE_ID | NUMBER | |||
PN_REQ_LINE_STATUS_FLAG | VARCHAR2 | (1) | ||
UOM_CODE | VARCHAR2 | (240) | ||
CURRENCY_CODE | VARCHAR2 | (240) | ||
ITEM_TYPE_CODE | VARCHAR2 | (240) | ||
ORDERED_QTY | NUMBER | |||
REVISED_OQ | NUMBER | |||
LIST_PRICE | NUMBER | |||
PROPOSED_PRICE | NUMBER | |||
COMPETITOR_PRICE | NUMBER | |||
DATAMART_NAME | VARCHAR2 | (240) | ||
ORG_LONG_DESC | VARCHAR2 | (240) | ||
ORG_SHORT_DESC | VARCHAR2 | (240) | ||
COMPETITOR_NAME | VARCHAR2 | (240) | ||
INVENTORY_ITEM_SHORT_DESC | VARCHAR2 | (240) | ||
INVENTORY_ITEM_LONG_DESC | VARCHAR2 | (240) | ||
GEOGRAPHY_SHORT_DESC | VARCHAR2 | (240) | ||
GEOGRAPHY_LONG_DESC | VARCHAR2 | (240) | ||
PAYMENT_TERM_SHORT_DESC | VARCHAR2 | (240) | ||
PAYMENT_TERM_LONG_DESC | VARCHAR2 | (240) | ||
CURRENCY_SHORT_DESC | VARCHAR2 | (240) | ||
UOM_SHORT_DESC | VARCHAR2 | (240) | ||
SHIP_METHOD_CODE | VARCHAR2 | (240) | ||
SHIP_METHOD_SHORT_DESC | VARCHAR2 | (240) | ||
SHIP_METHOD_LONG_DESC | VARCHAR2 | (240) | ||
COMMENTS | VARCHAR2 | (2000) | ||
ADDITIONAL_INFORMATION | VARCHAR2 | (2000) | ||
REGRESSION_SLOPE | NUMBER | |||
REGRESSION_INTERCEPT | NUMBER | |||
MEASURE1_NUMBER | NUMBER | |||
MEASURE2_NUMBER | NUMBER | |||
MEASURE3_NUMBER | NUMBER | |||
MEASURE4_NUMBER | NUMBER | |||
MEASURE5_NUMBER | NUMBER | |||
MEASURE6_NUMBER | NUMBER | |||
MEASURE7_NUMBER | NUMBER | |||
MEASURE8_NUMBER | NUMBER | |||
MEASURE9_NUMBER | NUMBER | |||
MEASURE10_NUMBER | NUMBER | |||
MEASURE1_CHAR | VARCHAR2 | (240) | ||
MEASURE2_CHAR | VARCHAR2 | (240) | ||
MEASURE3_CHAR | VARCHAR2 | (240) | ||
MEASURE4_CHAR | VARCHAR2 | (240) | ||
MEASURE5_CHAR | VARCHAR2 | (240) | ||
MEASURE6_CHAR | VARCHAR2 | (240) | ||
MEASURE7_CHAR | VARCHAR2 | (240) | ||
MEASURE8_CHAR | VARCHAR2 | (240) | ||
MEASURE9_CHAR | VARCHAR2 | (240) | ||
MEASURE10_CHAR | VARCHAR2 | (240) | ||
FREIGHT_CHARGES | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_LOGIN_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
REQUEST_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PN_INT_LINE_ID
, SOURCE_ID
, SOURCE_REF_HDR_ID
, SOURCE_REF_LINE_ID
, SOURCE_REQUEST_LINE_NUMBER
, PRICE_PLAN_ID
, ORG_ID
, INVENTORY_ITEM_ID
, GEOGRAPHY_ID
, PAYMENT_TERM_ID
, PR_SEGMENT_ID
, VOL_BAND_SK
, TOP_MDL_SRC_LINE_ID
, PN_REQ_LINE_STATUS_FLAG
, UOM_CODE
, CURRENCY_CODE
, ITEM_TYPE_CODE
, ORDERED_QTY
, REVISED_OQ
, LIST_PRICE
, PROPOSED_PRICE
, COMPETITOR_PRICE
, DATAMART_NAME
, ORG_LONG_DESC
, ORG_SHORT_DESC
, COMPETITOR_NAME
, INVENTORY_ITEM_SHORT_DESC
, INVENTORY_ITEM_LONG_DESC
, GEOGRAPHY_SHORT_DESC
, GEOGRAPHY_LONG_DESC
, PAYMENT_TERM_SHORT_DESC
, PAYMENT_TERM_LONG_DESC
, CURRENCY_SHORT_DESC
, UOM_SHORT_DESC
, SHIP_METHOD_CODE
, SHIP_METHOD_SHORT_DESC
, SHIP_METHOD_LONG_DESC
, COMMENTS
, ADDITIONAL_INFORMATION
, REGRESSION_SLOPE
, REGRESSION_INTERCEPT
, MEASURE1_NUMBER
, MEASURE2_NUMBER
, MEASURE3_NUMBER
, MEASURE4_NUMBER
, MEASURE5_NUMBER
, MEASURE6_NUMBER
, MEASURE7_NUMBER
, MEASURE8_NUMBER
, MEASURE9_NUMBER
, MEASURE10_NUMBER
, MEASURE1_CHAR
, MEASURE2_CHAR
, MEASURE3_CHAR
, MEASURE4_CHAR
, MEASURE5_CHAR
, MEASURE6_CHAR
, MEASURE7_CHAR
, MEASURE8_CHAR
, MEASURE9_CHAR
, MEASURE10_CHAR
, FREIGHT_CHARGES
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM QPR.QPR_PN_INT_LINES#;
|
|
|