[Home] [Help] [Dependency Information]
Object Name: | GML_SO_RESERVATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GML.GML_SO_RESERVATIONS_V |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
View for Batch Reservations
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 |
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;
APPS.GML_SO_RESERVATIONS_V is not referenced by any database object
|
|
|