[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_RESOURCE_CHARGES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Stores Charges associated with OPM job which has chargeable resource
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SR_INSTANCE_ID | NUMBER | Source Instance id | ||
RESOURCE_ID | NUMBER | Resource id | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
DEPARTMENT_ID | NUMBER | Department unique identifier | ||
ROUTING_SEQUENCE_ID | NUMBER | Routing used. | ||
WIP_ENTITY_ID | NUMBER | Wip entity id | ||
OPERATION_SEQUENCE_ID | NUMBER | Identifier of the routing operation generating the requirement | ||
OPERATION_SEQ_NUM | NUMBER | Operation seq Number | ||
RESOURCE_SEQ_NUM | NUMBER | Identifier of the planned resource requirements | ||
CHARGE_NUMBER | NUMBER | Charge identifier | ||
CHARGE_QUANTITY | NUMBER | Charge quantity | ||
CHARGE_START_DATETIME | DATE | Charge Start | ||
CHARGE_END_DATETIME | DATE | Charge End | ||
ALTERNATE_NUM | NUMBER | Alternate resource Number | ||
ORGAINZATION_CODE | VARCHAR2 | (7) | For Legacy | |
RESOURCE_CODE | VARCHAR2 | (10) | For Legacy | |
OPERATION_SEQ_CODE | VARCHAR2 | (10) | For Legacy | |
ROUTING_NAME | VARCHAR2 | (250) | Routing name in source | |
WIP_ENTITY_NAME | VARCHAR2 | (250) | Wip entity name in source | |
DELETED_FLAG | NUMBER | For marking record as delete | ||
REFRESH_ID | NUMBER | Refresh Identifier | ||
COMPANY_ID | NUMBER | For Legacy | ||
COMPANY_NAME | VARCHAR2 | (255) | For Legacy | |
SR_INSTANCE_CODE | VARCHAR2 | (3) | For Legacy | |
MESSAGE_ID | NUMBER | For Legacy | ||
PROCESS_FLAG | NUMBER | For Legacy | ||
ERROR_TEXT | VARCHAR2 | (2000) | For Legacy | |
ST_TRANSACTION_ID | NUMBER | For Legacy | ||
BATCH_ID | NUMBER | For Legacy | ||
DATA_SOURCE_TYPE | VARCHAR2 | (15) | For Legacy | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
CREATED_BY | NUMBER | Standard who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column | ||
REQUEST_ID | NUMBER | Standard who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard who column | ||
PROGRAM_ID | NUMBER | Standard who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT SR_INSTANCE_ID
, RESOURCE_ID
, ORGANIZATION_ID
, DEPARTMENT_ID
, ROUTING_SEQUENCE_ID
, WIP_ENTITY_ID
, OPERATION_SEQUENCE_ID
, OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM
, CHARGE_NUMBER
, CHARGE_QUANTITY
, CHARGE_START_DATETIME
, CHARGE_END_DATETIME
, ALTERNATE_NUM
, ORGAINZATION_CODE
, RESOURCE_CODE
, OPERATION_SEQ_CODE
, ROUTING_NAME
, WIP_ENTITY_NAME
, DELETED_FLAG
, REFRESH_ID
, COMPANY_ID
, COMPANY_NAME
, SR_INSTANCE_CODE
, MESSAGE_ID
, PROCESS_FLAG
, ERROR_TEXT
, ST_TRANSACTION_ID
, BATCH_ID
, DATA_SOURCE_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM MSC.MSC_ST_RESOURCE_CHARGES;
MSC.MSC_ST_RESOURCE_CHARGES does not reference any database object
MSC.MSC_ST_RESOURCE_CHARGES is referenced by following:
|
|
|