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

VIEW: APPS.GMP_SR_SHIPMENT_DATA_V

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

View Type

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


Shipment data view for Demand Planner


[View Source]

Columns
Name Datatype Length Mandatory Comments
SR_INV_ORG_PK NUMBER

Inventrory Organization ID
INV_ORG VARCHAR2 (0)
Inventory Organization code
SR_ITEM_PK NUMBER

Item Id
ITEM VARCHAR2 (0)
Item No.
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 Represntative ID
SALES_REP VARCHAR2 (0)
Sales represntative
SR_SHIP_TO_LOC_PK NUMBER

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

Book Date
REQUESTED_DATE DATE

Requested Date
PROMISED_DATE DATE

Promised Date
SCHEDULED_DATE DATE

Scheduled Date
SHIPPED_DATE DATE

Shipped Date
AMOUNT NUMBER

Amount for the line
QTY_SHIPPED NUMBER

Quantity Shipped
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

Original Item
SR_PARENT_ITEM_PK VARCHAR2 (0)
Original Item
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
,      SHIPPED_DATE
,      AMOUNT
,      QTY_SHIPPED
,      SR_USER_DEFINED1_PK
,      USER_DEFINED1
,      SR_USER_DEFINED2_PK
,      USER_DEFINED2
,      SR_ORIGINAL_ITEM_PK
,      SR_PARENT_ITEM_PK
FROM APPS.GMP_SR_SHIPMENT_DATA_V;

Dependencies

[top of page]

APPS.GMP_SR_SHIPMENT_DATA_V references the following:

SchemaSYS
TableDUAL

APPS.GMP_SR_SHIPMENT_DATA_V is not referenced by any database object