[Home] [Help] [Dependency Information]
Object Name: | GMD_SAMPLING_EVENT_REC_TYPE |
---|---|
Object Type: | TYPE |
Owner: | SYSTEM |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
RECEIPT_ID | NUMBER |
|
|
RECEIPT_NUMBER | NUMBER |
|
|
PO_HEADER_ID | NUMBER |
|
|
PO_NUMBER | NUMBER |
|
|
SAMPLING_EVENT_ID | NUMBER |
|
|
ORIGINAL_SPEC_VR_ID | NUMBER |
|
|
DISPOSITION | VARCHAR2 | (3) | |
SAMPLE_REQ_CNT | NUMBER |
|
|
SAMPLE_TAKEN_CNT | NUMBER |
|
|
SAMPLING_PLAN_ID | NUMBER |
|
|
EVENT_TYPE_CODE | VARCHAR2 | (1) | |
EVENT_ID | NUMBER |
|
|
INVENTORY_ITEM_ID | NUMBER |
|
|
REVISION | VARCHAR2 | (3) | |
ITEM_NUMBER | VARCHAR2 | (240) | |
LOT_NUMBER | VARCHAR2 | (80) | |
PARENT_LOT_NUMBER | VARCHAR2 | (80) | |
SUBINVENTORY | VARCHAR2 | (10) | |
LOCATOR_ID | NUMBER |
|
|
BATCH_ID | NUMBER |
|
|
BATCH_NO | VARCHAR2 | (32) | |
RECIPE_ID | NUMBER |
|
|
RECIPE_NUMBER | VARCHAR2 | (80) | |
RECIPE_VERS | NUMBER |
|
|
FORMULA_ID | NUMBER |
|
|
FORMULA_NO | VARCHAR2 | (32) | |
FORMULA_VERS | NUMBER |
|
|
FORMULALINE_ID | NUMBER |
|
|
FORMULALINE_NO | NUMBER |
|
|
ROUTING_ID | NUMBER |
|
|
OPRN_ID | NUMBER |
|
|
CHARGE | NUMBER |
|
|
CUST_ID | NUMBER |
|
|
CUST_NAME | VARCHAR2 | (360) | |
ORDER_ID | NUMBER |
|
|
ORDER_NUMBER | NUMBER |
|
|
ORDER_LINE_ID | NUMBER |
|
|
ORDER_LINE_NO | NUMBER |
|
|
ORG_ID | NUMBER |
|
|
ORGANIZATION_CODE | VARCHAR2 | (3) | |
SUPPLIER_ID | NUMBER |
|
|
SUPPLIER_NAME | VARCHAR2 | (240) | |
PO_LINE_ID | NUMBER |
|
|
PO_LINE_NUMBER | NUMBER |
|
|
RECEIPT_LINE_ID | NUMBER |
|
|
RECEIPT_LINE_NUMBER | NUMBER |
|
|
SUPPLIER_LOT_NO | VARCHAR2 | (32) | |
COMPLETE_IND | VARCHAR2 | (1) | |
SAMPLE_ID_TO_EVALUATE | NUMBER |
|
|
COMPOSITE_ID_TO_EVALUATE | NUMBER |
|
|
TEXT_CODE | NUMBER |
|
10 |
CREATION_DATE | DATE |
|
|
CREATED_BY_ID | NUMBER |
|
15 |
CREATED_BY_NAME | VARCHAR2 | (240) | |
LAST_UPDATED_BY_ID | NUMBER |
|
15 |
LAST_UPDATED_BY_NAME | VARCHAR2 | (240) | |
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATE_LOGIN | NUMBER |
|
15 |
SUPPLIER_SITE_ID | NUMBER |
|
|
SUPPLIER_SITE_NAME | VARCHAR2 | (240) | |
SHIP_TO_SITE_ID | NUMBER |
|
|
SHIP_TO_SITE_NAME | VARCHAR2 | (240) | |
STEP_ID | NUMBER |
|
|
STEP_NO | NUMBER |
|
|
LOT_RETEST_IND | VARCHAR2 | (1) | |
RECOMPOSITE_IND | VARCHAR2 | (1) | |
SAMPLE_ACTIVE_CNT | NUMBER |
|
|
ORGN_CODE | VARCHAR2 | (4) | |
RESOURCES | VARCHAR2 | (30) | |
INSTANCE_ID | NUMBER |
|
|
TIME_POINT_ID | NUMBER |
|
|
VARIANT_ID | NUMBER |
|
|
ARCHIVED_TAKEN | NUMBER |
|
|
RESERVED_TAKEN | NUMBER |
|
|
SAMPLE_EVENT_DISPS | GMD_EVENT_SPEC_DISPS_TAB_TYPE |
|
|
|
|