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

VIEW: APPS.GML_SO_RESERVATIONS_V

Object Details
Object Name: GML_SO_RESERVATIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGML.GML_SO_RESERVATIONS_V
Subobject Name:
Status: VALID

View Type

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


View for Batch Reservations


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_RES_ID NUMBER (15)
Reservation ID from GML_BATCH_SO
BATCH_ID NUMBER (15)
Batch ID
BATCH_NO VARCHAR2 (40)
Batch Number
BATCH_LINE_ID NUMBER (15)
Batch Line ID against which reservation is made
WHSE_CODE VARCHAR2 (4)
OPM To Warehouse Code
DELIVERY_DETAIL_ID NUMBER (15)
DELIVERY_DETAIL_ID for the delivery line
BATCH_TYPE NUMBER (15)
Batch Type to indicate whether a batch or Firm planned Order
BATCH_STATUS NUMBER (15)
Batch Status to indicate whether Pending , WIP, Completed
START_DATE DATE

Planned Start date for batch line
PLAN_CMPLT_DATE DATE

Planned Completion date for Batch line
RESERVED_QUANTITY NUMBER

RESERVED_QUANTITY2 NUMBER

PLANNED_QUANTITY NUMBER

PLANNED_QUANTITY2 NUMBER

COMMIT_QUANTITY NUMBER

COMMIT_QUANTITY2 NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_RES_ID
,      BATCH_ID
,      BATCH_NO
,      BATCH_LINE_ID
,      WHSE_CODE
,      DELIVERY_DETAIL_ID
,      BATCH_TYPE
,      BATCH_STATUS
,      START_DATE
,      PLAN_CMPLT_DATE
,      RESERVED_QUANTITY
,      RESERVED_QUANTITY2
,      PLANNED_QUANTITY
,      PLANNED_QUANTITY2
,      COMMIT_QUANTITY
,      COMMIT_QUANTITY2
FROM APPS.GML_SO_RESERVATIONS_V;

Dependencies

[top of page]

APPS.GML_SO_RESERVATIONS_V references the following:

SchemaAPPS
SynonymGML_BATCH_TMP

APPS.GML_SO_RESERVATIONS_V is not referenced by any database object