[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_ADJ_DATA_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Source view for adjustment measures.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INV_ORG_PK | NUMBER | Organization dimension key | ||
INV_ORG | VARCHAR2 | (0) | Inventory Organization | |
SR_ITEM_PK | NUMBER | Item dimension key | ||
ITEM | VARCHAR2 | (0) | Item | |
SR_CUSTOMER_PK | NUMBER | Customer dimension key | ||
CUSTOMER | VARCHAR2 | (0) | Customer | |
SR_SALES_CHANNEL_PK | VARCHAR2 | (40) | Sales channel dimension key | |
SALES_CHANNEL | VARCHAR2 | (0) | Sales channel | |
SR_SALES_REP_PK | NUMBER | Sales representative dimension key | ||
SALES_REP | VARCHAR2 | (0) | Sales representative | |
SR_SHIP_TO_LOC_PK | NUMBER | Geography dimension key | ||
SHIP_TO_LOC | VARCHAR2 | (0) | Geography | |
OU_ID | NUMBER | Organization unit | ||
BOOKED_DATE | DATE | Time dimension value | ||
ADJUSTED_AMOUNT | NUMBER | Adjusted amount per unit | ||
ADJ_AMOUNT_REVENUE | NUMBER | Adjusted amount revenue | ||
ADJ_PERCENTAGE | NUMBER | Adjustment percentage | ||
SR_USER_DEFINED1_PK | NUMBER | Not used | ||
USER_DEFINED1 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED2_PK | NUMBER | Not used | ||
USER_DEFINED2 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED3_PK | NUMBER | Not used | ||
USER_DEFINED3 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED4_PK | NUMBER | Not used | ||
USER_DEFINED4 | VARCHAR2 | (0) | Not used | |
SR_USER_DEFINED5_PK | NUMBER | Not used | ||
USER_DEFINED5 | VARCHAR2 | (0) | Not used | |
SR_ORDER_LINE_PK | NUMBER | Yes | Order dimension key | |
ORDERLINE | VARCHAR2 | (0) | Order line number | |
SR_ADJ_ID_PK | NUMBER | Adjustment dimension key | ||
ADJUSTMENT_ID | VARCHAR2 | (0) | Adjustment id | |
LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Modifier type |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INV_ORG_PK
, INV_ORG
, SR_ITEM_PK
, ITEM
, SR_CUSTOMER_PK
, CUSTOMER
, SR_SALES_CHANNEL_PK
, SALES_CHANNEL
, SR_SALES_REP_PK
, SALES_REP
, SR_SHIP_TO_LOC_PK
, SHIP_TO_LOC
, OU_ID
, BOOKED_DATE
, ADJUSTED_AMOUNT
, ADJ_AMOUNT_REVENUE
, ADJ_PERCENTAGE
, SR_USER_DEFINED1_PK
, USER_DEFINED1
, SR_USER_DEFINED2_PK
, USER_DEFINED2
, SR_USER_DEFINED3_PK
, USER_DEFINED3
, SR_USER_DEFINED4_PK
, USER_DEFINED4
, SR_USER_DEFINED5_PK
, USER_DEFINED5
, SR_ORDER_LINE_PK
, ORDERLINE
, SR_ADJ_ID_PK
, ADJUSTMENT_ID
, LIST_LINE_TYPE_CODE
FROM APPS.QPR_SR_ADJ_DATA_V;
APPS.QPR_SR_ADJ_DATA_V is not referenced by any database object
|
|
|