VIEW: APPS.GMD_COM_SPEC_VRS_VL

Source

View Text - Preformatted

SELECT spec_vr_id , spec_id, organization_id, 'I' spec_type, parent_lot_number, lot_number, subinventory, locator_id, spec_vr_status, start_date, end_date, sampling_plan_id, sample_inv_trans_ind, control_lot_attrib_ind, out_of_spec_lot_status_id, in_spec_lot_status_id, NULL 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, TO_NUMBER (NULL) batch_id, TO_NUMBER (NULL) recipe_id, NULL recipe_no, TO_NUMBER (NULL) recipe_version, TO_NUMBER (NULL) formula_id, TO_NUMBER (NULL) formulaline_id, NULL formula_no, TO_NUMBER (NULL) formula_vers, TO_NUMBER (NULL) routing_id, NULL routing_no, TO_NUMBER (NULL) routing_vers, TO_NUMBER (NULL) step_id, TO_NUMBER (NULL) step_no, TO_NUMBER (NULL) oprn_id, NULL oprn_no, TO_NUMBER (NULL) oprn_vers, TO_NUMBER (NULL) charge, TO_NUMBER (NULL) cust_id, TO_NUMBER (NULL) order_id, TO_NUMBER (NULL) order_line, TO_NUMBER (NULL) order_line_id, TO_NUMBER (NULL) ship_to_site_id, TO_NUMBER (NULL) org_id, TO_NUMBER (NULL) supplier_id, TO_NUMBER (NULL) supplier_site_id, TO_NUMBER (NULL) po_header_id, TO_NUMBER (NULL) po_line_id, NULL resources, TO_NUMBER (NULL) resource_instance_id, delete_mark, text_code, creation_date, created_by, last_updated_by, last_update_date, last_update_login, TO_NUMBER (NULL) material_detail_id, delayed_lpn_entry FROM GMD_INVENTORY_SPEC_VRS UNION ALL SELECT spec_vr_id, spec_id, organization_id, 'W' spec_type, NULL parent_lot_number, NULL lot_number, NULL subinventory, TO_NUMBER (NULL) locator_id, spec_vr_status, start_date, end_date, sampling_plan_id, sample_inv_trans_ind, control_lot_attrib_ind, out_of_spec_lot_status_id, in_spec_lot_status_id, control_batch_step_ind, lot_optional_on_sample, delayed_lot_entry, coa_type, coa_at_ship_ind, NULL 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, TO_NUMBER (NULL) cust_id, TO_NUMBER (NULL) order_id, TO_NUMBER (NULL) order_line, TO_NUMBER (NULL) order_line_id, TO_NUMBER (NULL) ship_to_site_id, TO_NUMBER (NULL) org_id, TO_NUMBER (NULL) supplier_id, TO_NUMBER (NULL) supplier_site_id, TO_NUMBER (NULL) po_header_id, TO_NUMBER (NULL) po_line_id, NULL resources, TO_NUMBER (NULL) resource_instance_id, delete_mark, text_code, creation_date, created_by, last_updated_by, last_update_date, last_update_login, material_detail_id, delayed_lpn_entry FROM GMD_WIP_SPEC_VRS UNION ALL SELECT spec_vr_id, spec_id, organization_id, 'C' spec_type, NULL parent_lot_number, NULL lot_number, NULL subinventory, TO_NUMBER (NULL) locator_id, spec_vr_status, start_date, end_date, sampling_plan_id, sample_inv_trans_ind, NULL control_lot_attrib_ind, TO_NUMBER (NULL) out_of_spec_lot_status_id, TO_NUMBER (NULL) in_spec_lot_status_id, NULL control_batch_step_ind, lot_optional_on_sample, NULL delayed_lot_entry, coa_type, coa_at_ship_ind, coa_at_invoice_ind, coa_req_from_supl_ind, NULL auto_sample_ind, TO_NUMBER (NULL) batch_id, TO_NUMBER (NULL) recipe_id, NULL recipe_no, TO_NUMBER (NULL) recipe_version, TO_NUMBER (NULL) formula_id, TO_NUMBER (NULL) formulaline_id, NULL formula_no, TO_NUMBER (NULL) formula_vers, TO_NUMBER (NULL) routing_id, NULL routing_no, TO_NUMBER (NULL) routing_vers, TO_NUMBER (NULL) step_id, TO_NUMBER (NULL) step_no, TO_NUMBER (NULL) oprn_id, NULL oprn_no, TO_NUMBER (NULL) oprn_vers, TO_NUMBER (NULL) charge, cust_id, order_id, order_line, order_line_id, ship_to_site_id, org_id, TO_NUMBER (NULL) supplier_id, TO_NUMBER (NULL) supplier_site_id, TO_NUMBER (NULL) po_header_id, TO_NUMBER (NULL) po_line_id, NULL resources, TO_NUMBER (NULL) resource_instance_id, delete_mark, text_code, creation_date, created_by, last_updated_by, last_update_date, last_update_login, TO_NUMBER (NULL) material_detail_id, NULL delayed_lpn_entry FROM GMD_CUSTOMER_SPEC_VRS UNION ALL SELECT spec_vr_id, spec_id, organization_id, 'S' spec_type, NULL parent_lot_number, NULL lot_number, NULL subinventory, TO_NUMBER (NULL) locator_id, spec_vr_status, start_date, end_date, sampling_plan_id, sample_inv_trans_ind, control_lot_attrib_ind, out_of_spec_lot_status_id, in_spec_lot_status_id, NULL control_batch_step_ind, lot_optional_on_sample, delayed_lot_entry, coa_type, NULL coa_at_ship_ind, NULL coa_at_invoice_ind, coa_req_from_supl_ind, auto_sample_ind, TO_NUMBER (NULL) batch_id, TO_NUMBER (NULL) recipe_id, NULL recipe_no, TO_NUMBER (NULL) recipe_version, TO_NUMBER (NULL) formula_id, TO_NUMBER (NULL) formulaline_id, NULL formula_no, TO_NUMBER (NULL) formula_vers, TO_NUMBER (NULL) routing_id, NULL routing_no, TO_NUMBER (NULL) routing_vers, TO_NUMBER (NULL) step_id, TO_NUMBER (NULL) step_no, TO_NUMBER (NULL) oprn_id, NULL oprn_no, TO_NUMBER (NULL) oprn_vers, TO_NUMBER (NULL) charge, TO_NUMBER (NULL) cust_id, TO_NUMBER (NULL) order_id, TO_NUMBER (NULL) order_line, TO_NUMBER (NULL) order_line_id, TO_NUMBER (NULL) ship_to_site_id, org_id, supplier_id, supplier_site_id, po_header_id, po_line_id, NULL resources, TO_NUMBER (NULL) resource_instance_id, delete_mark, text_code, creation_date, created_by, last_updated_by, last_update_date, last_update_login, TO_NUMBER (NULL) material_detail_id, delayed_lpn_entry FROM GMD_SUPPLIER_SPEC_VRS UNION ALL SELECT spec_vr_id, spec_id, DECODE (rule_type,'R', resource_organization_id,'L', locator_organization_id,TO_NUMBER (NULL)), rule_type, NULL parent_lot_number, NULL lot_number, subinventory, locator_id, spec_vr_status, start_date, end_date, sampling_plan_id, NULL sample_inv_trans_ind, NULL control_lot_attrib_ind, TO_NUMBER (NULL) out_of_spec_lot_status_id, TO_NUMBER (NULL) in_spec_lot_status_id, NULL control_batch_step_ind, NULL lot_optional_on_sample, NULL delayed_lot_entry, NULL coa_type, NULL coa_at_ship_ind, NULL coa_at_invoice_ind, NULL coa_req_from_supl_ind, NULL auto_sample_ind, TO_NUMBER (NULL) batch_id, TO_NUMBER (NULL) recipe_id, NULL recipe_no, TO_NUMBER (NULL) recipe_version, TO_NUMBER (NULL) formula_id, TO_NUMBER (NULL) formulaline_id, NULL formula_no, TO_NUMBER (NULL) formula_vers, TO_NUMBER (NULL) routing_id, NULL routing_no, TO_NUMBER (NULL) routing_vers, TO_NUMBER (NULL) step_id, TO_NUMBER (NULL) step_no, TO_NUMBER (NULL) oprn_id, NULL oprn_no, TO_NUMBER (NULL) oprn_vers, TO_NUMBER (NULL) charge, TO_NUMBER (NULL) cust_id, TO_NUMBER (NULL) order_id, TO_NUMBER (NULL) order_line, TO_NUMBER (NULL) order_line_id, TO_NUMBER (NULL) ship_to_site_id, TO_NUMBER (NULL) org_id, TO_NUMBER (NULL) supplier_id, TO_NUMBER (NULL) supplier_site_id, TO_NUMBER (NULL) po_header_id, TO_NUMBER (NULL) po_line_id, resources, resource_instance_id, delete_mark, text_code, creation_date, created_by, last_updated_by, last_update_date, last_update_login, TO_NUMBER (NULL) material_detail_id, NULL delayed_lpn_entry FROM GMD_MONITORING_SPEC_VRS UNION ALL SELECT spec_vr_id, spec_id, TO_NUMBER (NULL) organization_id, 'T' spec_type, NULL parent_lot_number, NULL lot_number, NULL subinventory, TO_NUMBER (NULL) locator_id, spec_vr_status, start_date, end_date, sampling_plan_id, NULL sample_inv_trans_ind, NULL control_lot_attrib_ind, TO_NUMBER (NULL) out_of_spec_lot_status_id, TO_NUMBER (NULL) in_spec_lot_status_id, NULL control_batch_step_ind, NULL lot_optional_on_sample, NULL delayed_lot_entry, NULL coa_type, NULL coa_at_ship_ind, NULL coa_at_invoice_ind, NULL coa_req_from_supl_ind, NULL auto_sample_ind, TO_NUMBER (NULL) batch_id, TO_NUMBER (NULL) recipe_id, NULL recipe_no, TO_NUMBER (NULL) recipe_version, TO_NUMBER (NULL) formula_id, TO_NUMBER (NULL) formulaline_id, NULL formula_no, TO_NUMBER (NULL) formula_vers, TO_NUMBER (NULL) routing_id, NULL routing_no, TO_NUMBER (NULL) routing_vers, TO_NUMBER (NULL) step_id, TO_NUMBER (NULL) step_no, TO_NUMBER (NULL) oprn_id, NULL oprn_no, TO_NUMBER (NULL) oprn_vers, TO_NUMBER (NULL) charge, TO_NUMBER (NULL) cust_id, TO_NUMBER (NULL) order_id, TO_NUMBER (NULL) order_line, TO_NUMBER (NULL) order_line_id, TO_NUMBER (NULL) ship_to_site_id, TO_NUMBER (NULL) org_id, TO_NUMBER (NULL) supplier_id, TO_NUMBER (NULL) supplier_site_id, TO_NUMBER (NULL) po_header_id, TO_NUMBER (NULL) po_line_id, NULL resources, TO_NUMBER (NULL) resource_instance_id, delete_mark, TO_NUMBER (NULL) text_code, creation_date, created_by, last_updated_by, last_update_date, last_update_login, TO_NUMBER (NULL) material_detail_id, NULL delayed_lpn_entry FROM GMD_STABILITY_SPEC_VRS

View Text - HTML Formatted

SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'I' SPEC_TYPE
, PARENT_LOT_NUMBER
, LOT_NUMBER
, SUBINVENTORY
, LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, CONTROL_LOT_ATTRIB_IND
, OUT_OF_SPEC_LOT_STATUS_ID
, IN_SPEC_LOT_STATUS_ID
, NULL 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
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
, DELAYED_LPN_ENTRY
FROM GMD_INVENTORY_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'W' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, CONTROL_LOT_ATTRIB_IND
, OUT_OF_SPEC_LOT_STATUS_ID
, IN_SPEC_LOT_STATUS_ID
, CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, DELAYED_LOT_ENTRY
, COA_TYPE
, COA_AT_SHIP_IND
, NULL 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
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MATERIAL_DETAIL_ID
, DELAYED_LPN_ENTRY
FROM GMD_WIP_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'C' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, NULL DELAYED_LOT_ENTRY
, COA_TYPE
, COA_AT_SHIP_IND
, COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, NULL AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, CUST_ID
, ORDER_ID
, ORDER_LINE
, ORDER_LINE_ID
, SHIP_TO_SITE_ID
, ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
, NULL DELAYED_LPN_ENTRY
FROM GMD_CUSTOMER_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'S' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, CONTROL_LOT_ATTRIB_IND
, OUT_OF_SPEC_LOT_STATUS_ID
, IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, DELAYED_LOT_ENTRY
, COA_TYPE
, NULL COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, ORG_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, PO_HEADER_ID
, PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
, DELAYED_LPN_ENTRY
FROM GMD_SUPPLIER_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, DECODE (RULE_TYPE
, 'R'
, RESOURCE_ORGANIZATION_ID
, 'L'
, LOCATOR_ORGANIZATION_ID
, TO_NUMBER (NULL))
, RULE_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, SUBINVENTORY
, LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, NULL SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, NULL LOT_OPTIONAL_ON_SAMPLE
, NULL DELAYED_LOT_ENTRY
, NULL COA_TYPE
, NULL COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, NULL COA_REQ_FROM_SUPL_IND
, NULL AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, RESOURCES
, RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
, NULL DELAYED_LPN_ENTRY
FROM GMD_MONITORING_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, TO_NUMBER (NULL) ORGANIZATION_ID
, 'T' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, NULL SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, NULL LOT_OPTIONAL_ON_SAMPLE
, NULL DELAYED_LOT_ENTRY
, NULL COA_TYPE
, NULL COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, NULL COA_REQ_FROM_SUPL_IND
, NULL AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TO_NUMBER (NULL) TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
, NULL DELAYED_LPN_ENTRY
FROM GMD_STABILITY_SPEC_VRS