[Home] [Help] [Dependency Information]
Object Name: | GMP_APS_OUTPUT_TBL# |
---|---|
Object Type: | VIEW |
Owner: | GMP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_ID | NUMBER | Yes | ||
ITEM_ID | NUMBER | |||
ORGANIZATION_CODE | VARCHAR2 | (4) | ||
ORGANIZATION_ID | NUMBER | Yes | ||
BATCH_ID | NUMBER | |||
WAREHOUSE_CODE | VARCHAR2 | (4) | ||
EFFECTIVITY_ID | NUMBER | |||
PLAN_QUANTITY | NUMBER | |||
PLAN_START_DATE | DATE | |||
PLAN_END_DATE | DATE | |||
ACTION_TYPE | NUMBER | |||
PROCESSED_IND | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
HEADER_ID | NUMBER | Yes | ||
SCHEDULING_METHOD | NUMBER | |||
ORDER_PRIORITY | NUMBER | |||
REQUIRED_COMPLETION_DATE | DATE | |||
INVENTORY_ITEM_ID | NUMBER | (16) | ||
FIRM_FLAG | NUMBER | (16) |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_ID
, ITEM_ID
, ORGANIZATION_CODE
, ORGANIZATION_ID
, BATCH_ID
, WAREHOUSE_CODE
, EFFECTIVITY_ID
, PLAN_QUANTITY
, PLAN_START_DATE
, PLAN_END_DATE
, ACTION_TYPE
, PROCESSED_IND
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, HEADER_ID
, SCHEDULING_METHOD
, ORDER_PRIORITY
, REQUIRED_COMPLETION_DATE
, INVENTORY_ITEM_ID
, FIRM_FLAG
FROM GMP.GMP_APS_OUTPUT_TBL#;
|
|
|