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

VIEW: GMP.MR_SIZE_TBL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHEDULE_ID NUMBER (10) Yes
MAX_FM_FORM_EFF NUMBER (10) Yes
MAX_FM_MATL_DTL NUMBER (10) Yes
MAX_FORMULA NUMBER (10) Yes
MAX_IC_PLNT_INV NUMBER (10) Yes
MAX_IC_SUMM_INV NUMBER (10) Yes
MAX_IC_TRAN_PND NUMBER (10) Yes
MAX_IC_WHSE_INV NUMBER (10) Yes
MAX_IC_WHSE_REL NUMBER (10) Yes
MAX_ITEM NUMBER (10) Yes
MAX_MR_SHCL_DTL NUMBER (10) Yes
MAX_MR_SHDY_DTL NUMBER (10) Yes
MAX_PS_SCHD_DTL NUMBER (10) Yes
MAX_PS_WHSE_EFF NUMBER (10) Yes
RESIZE_PERCENT NUMBER (10) Yes
MAX_PO_BPOS_DTL NUMBER (10) Yes
MAX_PO_BPOS_HDR NUMBER (10) Yes
MAX_PO_ORDR_DTL NUMBER (10) Yes
MAX_PO_RELS_SCH NUMBER (10) Yes
MAX_PS_SCHD_FOR NUMBER (10) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT SCHEDULE_ID
,      MAX_FM_FORM_EFF
,      MAX_FM_MATL_DTL
,      MAX_FORMULA
,      MAX_IC_PLNT_INV
,      MAX_IC_SUMM_INV
,      MAX_IC_TRAN_PND
,      MAX_IC_WHSE_INV
,      MAX_IC_WHSE_REL
,      MAX_ITEM
,      MAX_MR_SHCL_DTL
,      MAX_MR_SHDY_DTL
,      MAX_PS_SCHD_DTL
,      MAX_PS_WHSE_EFF
,      RESIZE_PERCENT
,      MAX_PO_BPOS_DTL
,      MAX_PO_BPOS_HDR
,      MAX_PO_ORDR_DTL
,      MAX_PO_RELS_SCH
,      MAX_PS_SCHD_FOR
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM GMP.MR_SIZE_TBL#;

Dependencies

[top of page]

GMP.MR_SIZE_TBL# references the following:

SchemaGMP
TableMR_SIZE_TBL
GMP.MR_SIZE_TBL# is referenced by following:

SchemaAPPS
SynonymMR_SIZE_TBL