[Home] [Help] [Dependency Information]
Object Name: | PMITS_QC_ALL_SPEC_VRS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_QC_ALL_SPEC_VRS_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SPEC_VR_ID | NUMBER | Unique Identifier for Spec Validity Rule | ||
SPEC_ID | NUMBER | Unique Identifier for Spec | ||
ORGN_CODE | CHAR | (3) | Organization | |
SPEC_TYPE | CHAR | (1) | Spec Type Code W-WIP, C-Customer, S-Supplier and I-Inventory | |
SPEC_TYPE_DISP | CHAR | (3) | Spec Type Meaning Resolved using GEM_LOOKUPS | |
SPEC_NAME | CHAR | (3) | Spec Name | |
SPEC_VERS | NUMBER | Spec Version | ||
ITEM_ID | NUMBER | Unique Identifier Item | ||
ITEM_NO | CHAR | (3) | ItemNumber | |
GRADE | CHAR | (3) | Quality Control Grade | |
SPEC_STATUS | NUMBER | Spec Status Code | ||
SPEC_STATUS_DESC | CHAR | (3) | Spec Status Meaning Resolved using GEM_LOOKUPS | |
LOT_ID | NUMBER | Unique Identifier Lot | ||
LOT_NO | CHAR | (3) | Lot Number | |
SUBLOT_NO | CHAR | (3) | Sublot Number | |
WHSE_CODE | CHAR | (3) | Warehouse Code | |
LOCATION | CHAR | (3) | Location | |
SPEC_VR_STATUS | NUMBER | Spec Validity Rule Status Code | ||
SPEC_VR_STATUS_DESC | CHAR | (3) | Spec Validity Rule Status Meaning Resolved using GEM_LOOKUPS | |
START_DATE | DATE | Start Date | ||
END_DATE | DATE | End date | ||
SAMPLING_PLAN_ID | NUMBER | Sampling Plan ID | ||
SAMPLE_INV_TRANS_IND | CHAR | (1) | Update Inventory Qty Indicator | |
SAMPLE_INV_TRANS_IND_DISP | CHAR | (3) | Update Inventory Qty Indicator Meaning Resolved using GEM_LOOKUPS | |
CONTROL_LOT_ATTRIB_IND | CHAR | (1) | Control Lot Status Code | |
CONTROL_LOT_ATTRIB_IND_DISP | CHAR | (3) | Control Lot Status Meaning Resolved using GEM_LOOKUPS | |
OUT_OF_SPEC_LOT_STATUS | CHAR | (3) | Out of Spec Lot Status | |
IN_SPEC_LOT_STATUS | CHAR | (3) | In Spec Lot Status | |
CONTROL_BATCH_STEP_IND | CHAR | (1) | Control Batch Step Status | |
CONTROL_BATCH_STEP_IND_DISP | CHAR | (3) | Control Batch Step Status Meaning Resolved using GEM_LOOKUPS | |
LOT_OPTIONAL_ON_SAMPLE | CHAR | (1) | Lot Optional on sample | |
COA_TYPE | CHAR | (1) | Certificate Type | |
COA_TYPE_DISP | CHAR | (3) | Certificate Type Meaning Resolved using GEM_LOOKUPS | |
COA_AT_SHIP_IND | CHAR | (1) | COA Required at Shippment Indicator | |
COA_AT_SHIP_IND_DISP | CHAR | (3) | COA Required at Shippment Indicator Meaning Resolved using GEM_LOOKUPS | |
COA_AT_INVOICE_IND | CHAR | (1) | COA Required at Invoice Indicator | |
COA_AT_INVOICE_IND_DISP | CHAR | (3) | COA Required at Invoice Indicator Meaning Resolved using GEM_LOOKUPS | |
COA_REQ_FROM_SUPL_IND | CHAR | (1) | COA Required from Supplier Indicator | |
COA_REQ_FROM_SUPL_IND_DISP | CHAR | (3) | COA Required from Supplier Indicator Meaning Resolved using GEM_LOOKUPS | |
BATCH_ID | NUMBER | Unique Identifier for Batch | ||
RECIPE_ID | NUMBER | Unique Identifier for Recipe | ||
RECIPE_NO | CHAR | (3) | Recipe Number | |
RECIPE_VERSION | NUMBER | Recipe Version | ||
FORMULA_ID | NUMBER | Unique Identifier for Formula | ||
FORMULALINE_ID | NUMBER | Unique Identifier for Formula Line | ||
FORMULA_NO | CHAR | (3) | Formula Number | |
FORMULA_VERS | NUMBER | Formula Version | ||
ROUTING_ID | NUMBER | Unique Identifier for Routing | ||
ROUTING_NO | CHAR | (3) | Routing Number | |
ROUTING_VERS | NUMBER | Routing Version | ||
STEP_ID | NUMBER | Unique Identifier for Routing Step | ||
STEP_NO | CHAR | (3) | Routing Step Number | |
OPRN_ID | NUMBER | Unique Identifier for Operation | ||
OPRN_NO | CHAR | (3) | Operation Number | |
OPRN_VERS | NUMBER | Operation Version | ||
CHARGE | NUMBER | Charge | ||
CUST_ID | NUMBER | Unique Identifier for Customer | ||
ORDER_ID | NUMBER | Unique Identifier for Order | ||
ORDER_LINE | NUMBER | Order Line | ||
ORDER_LINE_ID | NUMBER | Unique Identifier for Order Line | ||
SHIP_TO_SITE_ID | NUMBER | Unique Identifier for Ship to Site | ||
ORG_ID | NUMBER | Unique Identifier for Operating Unit | ||
SUPPLIER_ID | NUMBER | Unique Identifier for Supplier | ||
SUPPLIER_SITE_ID | NUMBER | Unique Identifier for Supplier Site | ||
PO_HEADER_ID | NUMBER | Unique Identifier for Purchase Order Header | ||
PO_LINE_ID | NUMBER | Unique Identifier for Purchase Order Line | ||
DELETE_MARK | NUMBER | Marked for purge | ||
TEXT_CODE | NUMBER | Text Code | ||
CREATION_DATE | DATE | ROW WHO Column | ||
CREATED_BY | NUMBER | ROW WHO Column | ||
LAST_UPDATED_BY | NUMBER | ROW WHO Column | ||
LAST_UPDATE_DATE | DATE | ROW WHO Column | ||
LAST_UPDATE_LOGIN | NUMBER | ROW WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT SPEC_VR_ID
, SPEC_ID
, ORGN_CODE
, SPEC_TYPE
, SPEC_TYPE_DISP
, SPEC_NAME
, SPEC_VERS
, ITEM_ID
, ITEM_NO
, GRADE
, SPEC_STATUS
, SPEC_STATUS_DESC
, LOT_ID
, LOT_NO
, SUBLOT_NO
, WHSE_CODE
, LOCATION
, SPEC_VR_STATUS
, SPEC_VR_STATUS_DESC
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, SAMPLE_INV_TRANS_IND_DISP
, CONTROL_LOT_ATTRIB_IND
, CONTROL_LOT_ATTRIB_IND_DISP
, OUT_OF_SPEC_LOT_STATUS
, IN_SPEC_LOT_STATUS
, CONTROL_BATCH_STEP_IND
, CONTROL_BATCH_STEP_IND_DISP
, LOT_OPTIONAL_ON_SAMPLE
, COA_TYPE
, COA_TYPE_DISP
, COA_AT_SHIP_IND
, COA_AT_SHIP_IND_DISP
, COA_AT_INVOICE_IND
, COA_AT_INVOICE_IND_DISP
, COA_REQ_FROM_SUPL_IND
, COA_REQ_FROM_SUPL_IND_DISP
, 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
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.PMITS_QC_ALL_SPEC_VRS_V;
APPS.PMITS_QC_ALL_SPEC_VRS_V is not referenced by any database object
|
|
|