[Home] [Help]
[Dependency Information]
Object Name: | MSD_SR_PROMOTIONAL_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.
This is the source view for promotional data. This view would be applied to an Oracle Applications 11i instance from which the promotional information is to be retrieved.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INV_ORG_PK | NUMBER | Inv Org Pk | ||
INV_ORG | VARCHAR2 | (0) | Inv Org | |
SR_ITEM_PK | NUMBER | Item Pk | ||
ITEM | VARCHAR2 | (0) | Item | |
SR_CUSTOMER_PK | NUMBER | Customer Pk | ||
CUSTOMER | VARCHAR2 | (0) | Customer | |
SR_SALES_CHANNEL_PK | VARCHAR2 | (40) | Sales Channel Pk | |
SALES_CHANNEL | VARCHAR2 | (0) | Sales Channel | |
SR_SALES_REP_PK | NUMBER | Sales Rep Pk | ||
SALES_REP | VARCHAR2 | (0) | Sales Rep | |
SR_SHIP_TO_LOC_PK | NUMBER | Ship To Loc Pk | ||
SHIP_TO_LOC | VARCHAR2 | (0) | Ship To Loc | |
SR_DEMAND_CLASS_PK | VARCHAR2 | (40) | Demand Classl Pk | |
BOOKED_DATE | DATE | Booked Date | ||
REQUESTED_DATE | DATE | Requested Date | ||
SCHEDULED_SHIP_DATE | DATE | Scheduled Ship Date | ||
SCHEDULED_ARRIVAL_DATE | DATE | Scheduled Arrival Date | ||
SHIPPED_DATE | DATE | Promised Date | ||
AMOUNT | NUMBER | Amount | ||
QUANTITY | NUMBER | Qty Ordered | ||
SR_USER_DEFINED1_PK | NUMBER | User Defined1 Pk | ||
USER_DEFINED1 | VARCHAR2 | (0) | User Defined1 | |
SR_USER_DEFINED2_PK | NUMBER | User Defined2 Pk | ||
USER_DEFINED2 | VARCHAR2 | (0) | User Defined2 | |
SR_ORIGINAL_ITEM_PK | NUMBER | Original Item Pk | ||
PROMOTION_SCOPE | CHAR | (1) | Source Parent Item Primary Key |
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
, SR_DEMAND_CLASS_PK
, BOOKED_DATE
, REQUESTED_DATE
, SCHEDULED_SHIP_DATE
, SCHEDULED_ARRIVAL_DATE
, SHIPPED_DATE
, AMOUNT
, QUANTITY
, SR_USER_DEFINED1_PK
, USER_DEFINED1
, SR_USER_DEFINED2_PK
, USER_DEFINED2
, SR_ORIGINAL_ITEM_PK
, PROMOTION_SCOPE
FROM APPS.MSD_SR_PROMOTIONAL_DATA_V;
APPS.MSD_SR_PROMOTIONAL_DATA_V is not referenced by any database object
|
|
|