[Home] [Help] [Dependency Information]
Object Name: | PS_SCHD_HDR# |
---|---|
Object Type: | VIEW |
Owner: | GMP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ID | NUMBER | (10) | Yes | |
ORGN_CODE | VARCHAR2 | (4) | ||
SCHEDULE | VARCHAR2 | (16) | Yes | |
SCHEDULE_DESC | VARCHAR2 | (40) | Yes | |
STOCK_IND | NUMBER | (5) | Yes | |
ORDER_IND | NUMBER | (5) | Yes | |
EXCESS_IND | NUMBER | (5) | ||
CONSUME_IND | NUMBER | (5) | Yes | |
CARRY_IND | NUMBER | (5) | ||
BLANKET_IND | NUMBER | (5) | ||
ACTIVE_IND | NUMBER | (5) | Yes | |
BPO_IND | NUMBER | (5) | ||
BPO_SUGGEST | NUMBER | (5) | ||
INNER_TIMEFENCE | NUMBER | |||
OUTER_TIMEFENCE | NUMBER | |||
MRP_HORIZON | NUMBER | Yes | ||
NO_DAYS | NUMBER | (10) | Yes | |
NO_WEEKS | NUMBER | (10) | Yes | |
NO_4WEEKS | NUMBER | (10) | Yes | |
NO_13WEEKS | NUMBER | (10) | Yes | |
IN_USE | NUMBER | (10) | ||
DELETE_MARK | NUMBER | (5) | Yes | |
TEXT_CODE | NUMBER | (10) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | |||
NONNET_IND | NUMBER | (5) |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_ID
, ORGN_CODE
, SCHEDULE
, SCHEDULE_DESC
, STOCK_IND
, ORDER_IND
, EXCESS_IND
, CONSUME_IND
, CARRY_IND
, BLANKET_IND
, ACTIVE_IND
, BPO_IND
, BPO_SUGGEST
, INNER_TIMEFENCE
, OUTER_TIMEFENCE
, MRP_HORIZON
, NO_DAYS
, NO_WEEKS
, NO_4WEEKS
, NO_13WEEKS
, IN_USE
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, NONNET_IND
FROM GMP.PS_SCHD_HDR#;
|
|
|