[Home] [Help] [Dependency Information]
Object Name: | GMD_ALL_SPEC_VRS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | GMD.GMD_ALL_SPEC_VRS_VL |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPEC_VR_ID | NUMBER | Specification validity rule identifier; db-seq | ||
SPEC_ID | NUMBER | Specification identifier | ||
ORGANIZATION_ID | NUMBER | This is organization ID | ||
ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SPEC_TYPE | VARCHAR2 | (1) | ||
SPEC_NAME | VARCHAR2 | (80) | ||
SPEC_VERS | NUMBER | (10) | ||
OWNER_ORGANIZATION_ID | NUMBER | |||
OWNER_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ITEM_NUMBER | VARCHAR2 | (40) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
REVISION | VARCHAR2 | (3) | ||
GRADE_CODE | VARCHAR2 | (150) | ||
SPEC_STATUS | NUMBER | (5) | ||
SPEC_STATUS_DESC | VARCHAR2 | (80) | ||
PARENT_LOT_NUMBER | VARCHAR2 | (80) | ||
LOT_NUMBER | VARCHAR2 | (80) | ||
SUBINVENTORY | VARCHAR2 | (10) | ||
LOCATOR_ID | NUMBER | |||
LOCATOR | VARCHAR2 | (1) | ||
SPEC_VR_STATUS | NUMBER | |||
SPEC_VR_STATUS_DESC | VARCHAR2 | (80) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
SAMPLING_PLAN_ID | NUMBER | |||
SAMPLE_INV_TRANS_IND | VARCHAR2 | (1) | ||
CONTROL_LOT_ATTRIB_IND | VARCHAR2 | (1) | ||
OUT_OF_SPEC_LOT_STATUS_ID | NUMBER | |||
OUT_OF_SPEC_LOT_STATUS_CODE | VARCHAR2 | (80) | ||
IN_SPEC_LOT_STATUS_ID | NUMBER | |||
IN_SPEC_LOT_STATUS_CODE | VARCHAR2 | (80) | ||
CONTROL_BATCH_STEP_IND | VARCHAR2 | (1) | ||
LOT_OPTIONAL_ON_SAMPLE | VARCHAR2 | (1) | ||
DELAYED_LOT_ENTRY | VARCHAR2 | (1) | ||
COA_TYPE | VARCHAR2 | (1) | ||
COA_AT_SHIP_IND | VARCHAR2 | (1) | ||
COA_AT_INVOICE_IND | VARCHAR2 | (1) | ||
COA_REQ_FROM_SUPL_IND | VARCHAR2 | (1) | ||
AUTO_SAMPLE_IND | VARCHAR2 | (1) | ||
BATCH_ID | NUMBER | |||
RECIPE_ID | NUMBER | |||
RECIPE_NO | VARCHAR2 | (32) | ||
RECIPE_VERSION | NUMBER | |||
FORMULA_ID | NUMBER | |||
FORMULALINE_ID | NUMBER | |||
FORMULA_NO | VARCHAR2 | (32) | ||
FORMULA_VERS | NUMBER | |||
ROUTING_ID | NUMBER | |||
ROUTING_NO | VARCHAR2 | (32) | ||
ROUTING_VERS | NUMBER | |||
STEP_ID | NUMBER | |||
STEP_NO | NUMBER | |||
OPRN_ID | NUMBER | |||
OPRN_NO | VARCHAR2 | (16) | ||
OPRN_VERS | NUMBER | |||
CHARGE | NUMBER | |||
CUST_ID | NUMBER | |||
ORDER_ID | NUMBER | |||
ORDER_LINE | NUMBER | |||
ORDER_LINE_ID | NUMBER | |||
SHIP_TO_SITE_ID | NUMBER | |||
ORG_ID | NUMBER | |||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | |||
PO_LINE_ID | NUMBER | |||
RESOURCES | VARCHAR2 | (16) | ||
RESOURCE_INSTANCE_ID | NUMBER | |||
DELETE_MARK | NUMBER | (5) | ||
TEXT_CODE | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
MATERIAL_DETAIL_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, ORGANIZATION_CODE
, SPEC_TYPE
, SPEC_NAME
, SPEC_VERS
, OWNER_ORGANIZATION_ID
, OWNER_ID
, INVENTORY_ITEM_ID
, ITEM_NUMBER
, DESCRIPTION
, REVISION
, GRADE_CODE
, SPEC_STATUS
, SPEC_STATUS_DESC
, PARENT_LOT_NUMBER
, LOT_NUMBER
, SUBINVENTORY
, LOCATOR_ID
, LOCATOR
, SPEC_VR_STATUS
, SPEC_VR_STATUS_DESC
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, CONTROL_LOT_ATTRIB_IND
, OUT_OF_SPEC_LOT_STATUS_ID
, OUT_OF_SPEC_LOT_STATUS_CODE
, IN_SPEC_LOT_STATUS_ID
, IN_SPEC_LOT_STATUS_CODE
, CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, DELAYED_LOT_ENTRY
, COA_TYPE
, COA_AT_SHIP_IND
, COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, AUTO_SAMPLE_IND
, BATCH_ID
, RECIPE_ID
, RECIPE_NO
, RECIPE_VERSION
, FORMULA_ID
, FORMULALINE_ID
, FORMULA_NO
, FORMULA_VERS
, ROUTING_ID
, ROUTING_NO
, ROUTING_VERS
, STEP_ID
, STEP_NO
, OPRN_ID
, OPRN_NO
, OPRN_VERS
, CHARGE
, CUST_ID
, ORDER_ID
, ORDER_LINE
, ORDER_LINE_ID
, SHIP_TO_SITE_ID
, ORG_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, PO_HEADER_ID
, PO_LINE_ID
, RESOURCES
, RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MATERIAL_DETAIL_ID
FROM APPS.GMD_ALL_SPEC_VRS_VL;
|
|
|