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

VIEW: WIP.WIP_OPS_RES_INTERFACE#

Object Details
Object Name: WIP_OPS_RES_INTERFACE#
Object Type: VIEW
Owner: WIP
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
WIP_ENTITY_ID NUMBER

ORGANIZATION_ID NUMBER

OPERATION_SEQ_NUM NUMBER

RESOURCE_SEQ_NUM NUMBER

RESOURCE_ID NUMBER

UOM_CODE VARCHAR2 (10)
BASIS_TYPE NUMBER

USAGE_RATE_OR_AMOUNT NUMBER

SCHEDULED_FLAG NUMBER

FIRM_FLAG NUMBER

ASSIGNED_UNITS NUMBER

MAXIMUM_ASSIGNED_UNITS NUMBER

AUTOCHARGE_TYPE NUMBER

STANDARD_RATE_FLAG NUMBER

APPLIED_RESOURCE_UNITS NUMBER

APPLIED_RESOURCE_VALUE NUMBER

START_DATE DATE

COMPLETION_DATE DATE

SCHEDULE_SEQ_NUM NUMBER

DEPARTMENT_ID NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

HEADER_ID NUMBER

BATCH_ID NUMBER

ROW_ID NUMBER

OP_START_DATE DATE

OP_COMPLETION_DATE DATE

OP_DESCRIPTION VARCHAR2 (240)
OP_MINIMUM_TRANSFER_QUANTITY NUMBER

Query Text

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


SELECT WIP_ENTITY_ID
,      ORGANIZATION_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      RESOURCE_ID
,      UOM_CODE
,      BASIS_TYPE
,      USAGE_RATE_OR_AMOUNT
,      SCHEDULED_FLAG
,      FIRM_FLAG
,      ASSIGNED_UNITS
,      MAXIMUM_ASSIGNED_UNITS
,      AUTOCHARGE_TYPE
,      STANDARD_RATE_FLAG
,      APPLIED_RESOURCE_UNITS
,      APPLIED_RESOURCE_VALUE
,      START_DATE
,      COMPLETION_DATE
,      SCHEDULE_SEQ_NUM
,      DEPARTMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      HEADER_ID
,      BATCH_ID
,      ROW_ID
,      OP_START_DATE
,      OP_COMPLETION_DATE
,      OP_DESCRIPTION
,      OP_MINIMUM_TRANSFER_QUANTITY
FROM WIP.WIP_OPS_RES_INTERFACE#;

Dependencies

[top of page]

WIP.WIP_OPS_RES_INTERFACE# references the following:

SchemaWIP
TableWIP_OPS_RES_INTERFACE
WIP.WIP_OPS_RES_INTERFACE# is referenced by following:

SchemaAPPS
SynonymWIP_OPS_RES_INTERFACE