[Home] [Help] [Dependency Information]
Object Name: | QPR_SR_OFFADJ_CD_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.
Off-Invoice adjustment source view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INV_ORG_PK | NUMBER | Organization key | ||
INV_ORG | VARCHAR2 | (0) | Inventory organization | |
SR_ITEM_PK | NUMBER | Item key | ||
ITEM | VARCHAR2 | (0) | Item | |
SR_CUSTOMER_PK | NUMBER | Customer key | ||
CUSTOMER | VARCHAR2 | (0) | Customer | |
SR_SALES_CHANNEL_PK | VARCHAR2 | (40) | Sales channel key | |
SALES_CHANNEL | VARCHAR2 | (0) | Sales channel | |
SR_SALES_REP_PK | NUMBER | Sales rep key | ||
SALES_REP | VARCHAR2 | (0) | Sales representative | |
SR_SHIP_TO_LOC_PK | NUMBER | Geography key | ||
SHIP_TO_LOC | VARCHAR2 | (0) | Geography | |
OU_ID | NUMBER | Organization unit | ||
BOOKED_DATE | DATE | Time dimension value | ||
TRX_DATE | DATE | Transaction date | ||
ADJUSTED_AMOUNT | NUMBER | Adjustment amount per unit | ||
ADJ_AMOUNT_REVENUE | NUMBER | Adjustment amount revenue | ||
ADJ_PERCENTAGE | VARCHAR2 | (0) | 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 key | |
ORDER_LINE_ID | VARCHAR2 | (0) | Order line | |
SR_ADJ_ID_PK | VARCHAR2 | (43) | Off invoice adjustment key | |
ADJUSTMENT_ID | VARCHAR2 | (0) | Off invoice adjustment |
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
, TRX_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
, ORDER_LINE_ID
, SR_ADJ_ID_PK
, ADJUSTMENT_ID
FROM APPS.QPR_SR_OFFADJ_CD_DATA_V;
APPS.QPR_SR_OFFADJ_CD_DATA_V is not referenced by any database object
|
|
|