[Home] [Help]
[Dependency Information]
[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
|
|
SYS
STANDARD
- show dependent code
SYSTEM
GMD_EVENT_SPEC_DISPS_TAB_TYPE
APPS
GMD_OUTBOUND_APIS_PUB
- show dependent code
SYSTEM
GMD_SAMPLING_EVENTS_TAB_TYPE
|
|
|
|