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

VIEW: GMP.PS_SCHD_HDR#

Object Details
Object Name: PS_SCHD_HDR#
Object Type: VIEW
Owner: GMP
Subobject Name:
Status: VALID

[View Source]

Columns
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)
Query Text

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#;

Dependencies

[top of page]

GMP.PS_SCHD_HDR# references the following:

SchemaGMP
TablePS_SCHD_HDR
GMP.PS_SCHD_HDR# is referenced by following:

SchemaAPPS
SynonymPS_SCHD_HDR