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

VIEW: GMI.IC_CYCL_HDR#

Object Details
Object Name: IC_CYCL_HDR#
Object Type: VIEW
Owner: GMI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CYCLE_ID NUMBER (10) Yes
CYCLE_NO VARCHAR2 (32) Yes
CYCLE_SOURCE NUMBER (5) Yes
CYCLE_DESC VARCHAR2 (70) Yes
WHSE_CODE VARCHAR2 (4) Yes
ORGN_CODE VARCHAR2 (4) Yes
PRINT_COUNT NUMBER (5) Yes
PRINT_FORMAT NUMBER (5) Yes
UPDATE_METHOD NUMBER (5) Yes
CYCLESTART_DT DATE
Yes
CYCLESCHESEND_DT DATE
Yes
CYCLEEND_DT DATE
Yes
ACTUALSTART_DT DATE
Yes
INCLCTL_IND NUMBER (5) Yes
INCLSUPER_IND NUMBER (5) Yes
INCLEXCEPT_IND NUMBER (5) Yes
IN_USE NUMBER (10)
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
DELETE_MARK NUMBER (5) Yes
TEXT_CODE NUMBER (10)
LAST_UPDATE_LOGIN NUMBER (15)
EXCLZERO_IND NUMBER (1) Yes
EXCLNEG_IND NUMBER (1) Yes
Query Text

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


SELECT CYCLE_ID
,      CYCLE_NO
,      CYCLE_SOURCE
,      CYCLE_DESC
,      WHSE_CODE
,      ORGN_CODE
,      PRINT_COUNT
,      PRINT_FORMAT
,      UPDATE_METHOD
,      CYCLESTART_DT
,      CYCLESCHESEND_DT
,      CYCLEEND_DT
,      ACTUALSTART_DT
,      INCLCTL_IND
,      INCLSUPER_IND
,      INCLEXCEPT_IND
,      IN_USE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      EXCLZERO_IND
,      EXCLNEG_IND
FROM GMI.IC_CYCL_HDR#;

Dependencies

[top of page]

GMI.IC_CYCL_HDR# references the following:

SchemaGMI
TableIC_CYCL_HDR
GMI.IC_CYCL_HDR# is referenced by following:

SchemaAPPS
SynonymIC_CYCL_HDR