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

VIEW: APPS.GMP_SR_BOOKING_DATA_V

Object Details
Object Name: GMP_SR_BOOKING_DATA_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMP.GMP_SR_BOOKING_DATA_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


OPM Orders Booking data - Demand Planner


[View Source]

Columns
Name Datatype Length Mandatory Comments
SR_INV_ORG_PK NUMBER

Inventory Org Id
INV_ORG VARCHAR2 (0)
Inventory Org Name
SR_ITEM_PK NUMBER

Inventory Item Id
ITEM VARCHAR2 (0)
Item Number
SR_CUSTOMER_PK NUMBER

Customer Id
CUSTOMER VARCHAR2 (0)
Customer Name
SR_SALES_CHANNEL_PK VARCHAR2 (0)
Sales Channel Id
SALES_CHANNEL VARCHAR2 (0)
Sales Channel
SR_SALES_REP_PK NUMBER

Sales Rep ID
SALES_REP VARCHAR2 (0)
Sales Rep
SR_SHIP_TO_LOC_PK NUMBER

Ship To Location Id
SHIP_TO_LOC VARCHAR2 (0)
Ship To Location
BOOKED_DATE DATE

Booking Date
REQUESTED_DATE DATE

Requested Date
PROMISED_DATE DATE

Promised Date
SCHEDULED_DATE DATE

Schedueld Date
AMOUNT NUMBER

Amount
QTY_ORDERED NUMBER

Quantity Ordered
SR_USER_DEFINED1_PK NUMBER

User Defined
USER_DEFINED1 VARCHAR2 (0)
User Defined
SR_USER_DEFINED2_PK NUMBER

User Defined
USER_DEFINED2 VARCHAR2 (0)
User Defined
SR_ORIGINAL_ITEM_PK NUMBER

Orginal Item ID
SR_PARENT_ITEM_PK VARCHAR2 (0)
Parent Item Id
Query Text

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
,      BOOKED_DATE
,      REQUESTED_DATE
,      PROMISED_DATE
,      SCHEDULED_DATE
,      AMOUNT
,      QTY_ORDERED
,      SR_USER_DEFINED1_PK
,      USER_DEFINED1
,      SR_USER_DEFINED2_PK
,      USER_DEFINED2
,      SR_ORIGINAL_ITEM_PK
,      SR_PARENT_ITEM_PK
FROM APPS.GMP_SR_BOOKING_DATA_V;

Dependencies

[top of page]

APPS.GMP_SR_BOOKING_DATA_V references the following:

SchemaSYS
TableDUAL

APPS.GMP_SR_BOOKING_DATA_V is not referenced by any database object