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

MultiLingual view (a language resolved view of the data.)


View for Shipment data from OPM schema (for collecting into Demand Planner)


[View Source]

Columns
Name Datatype Length Mandatory Comments
SR_INV_ORG_PK NUMBER

INV_ORG VARCHAR2 (0)
SR_ITEM_PK NUMBER

ITEM VARCHAR2 (0)
SR_CUSTOMER_PK NUMBER

CUSTOMER VARCHAR2 (0)
SR_SALES_CHANNEL_PK VARCHAR2 (0)
SALES_CHANNEL VARCHAR2 (0)
SR_SALES_REP_PK NUMBER

SALES_REP VARCHAR2 (0)
SR_SHIP_TO_LOC_PK NUMBER

SHIP_TO_LOC VARCHAR2 (0)
BOOKED_DATE DATE

REQUESTED_DATE DATE

PROMISED_DATE DATE

SCHEDULED_DATE DATE

SHIPPED_DATE DATE

AMOUNT NUMBER

QTY_SHIPPED NUMBER

SR_USER_DEFINED1_PK NUMBER

USER_DEFINED1 VARCHAR2 (0)
SR_USER_DEFINED2_PK NUMBER

USER_DEFINED2 VARCHAR2 (0)
SR_ORIGINAL_ITEM_PK NUMBER

SR_PARENT_ITEM_PK VARCHAR2 (0)
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