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

VIEW: GMP.MR_ACTN_TBL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
MRP_ID NUMBER (10) Yes
ACTION_NO NUMBER (10) Yes
ITEM_ID NUMBER (10) Yes
WHSE_CODE VARCHAR2 (4) Yes
EVENT_DATE DATE
Yes
INVENTORY_DATE DATE
Yes
DOC_TYPE VARCHAR2 (4)
DOC_ID NUMBER (10)
MESSAGE_CODE VARCHAR2 (32) Yes
FORMULA_ID NUMBER (10)
MRP_MSG_IND NUMBER (5) Yes
PROJ_BALANCE_QTY NUMBER
Yes
ACTION_QTY NUMBER
Yes
WHSE_CODE_2 VARCHAR2 (4)
NET_REQ_ACTION_REF NUMBER (10) Yes
ORGN_CODE VARCHAR2 (4)
STATUS_IND NUMBER (5) Yes
LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

FMEFF_ID NUMBER (15)
Query Text

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


SELECT MRP_ID
,      ACTION_NO
,      ITEM_ID
,      WHSE_CODE
,      EVENT_DATE
,      INVENTORY_DATE
,      DOC_TYPE
,      DOC_ID
,      MESSAGE_CODE
,      FORMULA_ID
,      MRP_MSG_IND
,      PROJ_BALANCE_QTY
,      ACTION_QTY
,      WHSE_CODE_2
,      NET_REQ_ACTION_REF
,      ORGN_CODE
,      STATUS_IND
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FMEFF_ID
FROM GMP.MR_ACTN_TBL#;

Dependencies

[top of page]

GMP.MR_ACTN_TBL# references the following:

SchemaGMP
TableMR_ACTN_TBL
GMP.MR_ACTN_TBL# is referenced by following:

SchemaAPPS
SynonymMR_ACTN_TBL