VIEW: GMD.GMD_SAMPLING_EVENTS#

Source

View Text - Preformatted

select RECEIPT_ID RECEIPT_ID, PO_HEADER_ID PO_HEADER_ID, SAMPLING_EVENT_ID SAMPLING_EVENT_ID, ORIGINAL_SPEC_VR_ID ORIGINAL_SPEC_VR_ID, DISPOSITION DISPOSITION, SAMPLE_REQ_CNT SAMPLE_REQ_CNT, SAMPLE_TAKEN_CNT SAMPLE_TAKEN_CNT, SAMPLING_PLAN_ID SAMPLING_PLAN_ID, EVENT_TYPE_CODE EVENT_TYPE_CODE, EVENT_ID EVENT_ID, SOURCE SOURCE, ITEM_ID ITEM_ID, LOT_ID LOT_ID, LOT_NO LOT_NO, SUBLOT_NO SUBLOT_NO, WHSE_CODE WHSE_CODE, LOCATION LOCATION, BATCH_ID BATCH_ID, RECIPE_ID RECIPE_ID, FORMULA_ID FORMULA_ID, FORMULALINE_ID FORMULALINE_ID, ROUTING_ID ROUTING_ID, OPRN_ID OPRN_ID, CHARGE CHARGE, CUST_ID CUST_ID, ORDER_ID ORDER_ID, ORDER_LINE_ID ORDER_LINE_ID, ORG_ID ORG_ID, SUPPLIER_ID SUPPLIER_ID, PO_LINE_ID PO_LINE_ID, RECEIPT_LINE_ID RECEIPT_LINE_ID, SUPPLIER_LOT_NO SUPPLIER_LOT_NO, COMPLETE_IND COMPLETE_IND, SAMPLE_ID_TO_EVALUATE SAMPLE_ID_TO_EVALUATE, COMPOSITE_ID_TO_EVALUATE COMPOSITE_ID_TO_EVALUATE, TEXT_CODE TEXT_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, STEP_ID STEP_ID, STEP_NO STEP_NO, LOT_RETEST_IND LOT_RETEST_IND, RECOMPOSITE_IND RECOMPOSITE_IND, SAMPLE_ACTIVE_CNT SAMPLE_ACTIVE_CNT, INSTANCE_ID INSTANCE_ID, RESOURCES RESOURCES, SAMPLE_TYPE SAMPLE_TYPE, TIME_POINT_ID TIME_POINT_ID, VARIANT_ID VARIANT_ID, ORGN_CODE ORGN_CODE, ARCHIVED_TAKEN ARCHIVED_TAKEN, RESERVED_TAKEN RESERVED_TAKEN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, LOCATOR_ID LOCATOR_ID, LOT_NUMBER LOT_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, PARENT_LOT_NUMBER PARENT_LOT_NUMBER, REVISION REVISION, SUBINVENTORY SUBINVENTORY, MIGRATED_IND MIGRATED_IND, PLAN_ID PLAN_ID, COLLECTION_ID COLLECTION_ID, OCCURRENCE OCCURRENCE, MATERIAL_DETAIL_ID MATERIAL_DETAIL_ID, LPN_ID LPN_ID from "GMD"."GMD_SAMPLING_EVENTS"

View Text - HTML Formatted

SELECT RECEIPT_ID RECEIPT_ID
, PO_HEADER_ID PO_HEADER_ID
, SAMPLING_EVENT_ID SAMPLING_EVENT_ID
, ORIGINAL_SPEC_VR_ID ORIGINAL_SPEC_VR_ID
, DISPOSITION DISPOSITION
, SAMPLE_REQ_CNT SAMPLE_REQ_CNT
, SAMPLE_TAKEN_CNT SAMPLE_TAKEN_CNT
, SAMPLING_PLAN_ID SAMPLING_PLAN_ID
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, EVENT_ID EVENT_ID
, SOURCE SOURCE
, ITEM_ID ITEM_ID
, LOT_ID LOT_ID
, LOT_NO LOT_NO
, SUBLOT_NO SUBLOT_NO
, WHSE_CODE WHSE_CODE
, LOCATION LOCATION
, BATCH_ID BATCH_ID
, RECIPE_ID RECIPE_ID
, FORMULA_ID FORMULA_ID
, FORMULALINE_ID FORMULALINE_ID
, ROUTING_ID ROUTING_ID
, OPRN_ID OPRN_ID
, CHARGE CHARGE
, CUST_ID CUST_ID
, ORDER_ID ORDER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, ORG_ID ORG_ID
, SUPPLIER_ID SUPPLIER_ID
, PO_LINE_ID PO_LINE_ID
, RECEIPT_LINE_ID RECEIPT_LINE_ID
, SUPPLIER_LOT_NO SUPPLIER_LOT_NO
, COMPLETE_IND COMPLETE_IND
, SAMPLE_ID_TO_EVALUATE SAMPLE_ID_TO_EVALUATE
, COMPOSITE_ID_TO_EVALUATE COMPOSITE_ID_TO_EVALUATE
, TEXT_CODE TEXT_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SHIP_TO_SITE_ID SHIP_TO_SITE_ID
, STEP_ID STEP_ID
, STEP_NO STEP_NO
, LOT_RETEST_IND LOT_RETEST_IND
, RECOMPOSITE_IND RECOMPOSITE_IND
, SAMPLE_ACTIVE_CNT SAMPLE_ACTIVE_CNT
, INSTANCE_ID INSTANCE_ID
, RESOURCES RESOURCES
, SAMPLE_TYPE SAMPLE_TYPE
, TIME_POINT_ID TIME_POINT_ID
, VARIANT_ID VARIANT_ID
, ORGN_CODE ORGN_CODE
, ARCHIVED_TAKEN ARCHIVED_TAKEN
, RESERVED_TAKEN RESERVED_TAKEN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, LOCATOR_ID LOCATOR_ID
, LOT_NUMBER LOT_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, PARENT_LOT_NUMBER PARENT_LOT_NUMBER
, REVISION REVISION
, SUBINVENTORY SUBINVENTORY
, MIGRATED_IND MIGRATED_IND
, PLAN_ID PLAN_ID
, COLLECTION_ID COLLECTION_ID
, OCCURRENCE OCCURRENCE
, MATERIAL_DETAIL_ID MATERIAL_DETAIL_ID
, LPN_ID LPN_ID
FROM "GMD"."GMD_SAMPLING_EVENTS"