VIEW: GMD.LM_SPRD_DTL#

Source

View Text - Preformatted

select LINE_ID LINE_ID, LAB_TYPE LAB_TYPE, SPRD_ID SPRD_ID, LINE_TYPE LINE_TYPE, LINE_NO LINE_NO, ITEM_ID ITEM_ID, QTY QTY, ITEM_UM ITEM_UM, TEXT_CODE TEXT_CODE, TPFORMULA_ID TPFORMULA_ID, FORMULALINE_ID FORMULALINE_ID, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ORGN_CODE ORGN_CODE, ROLLUP_IND ROLLUP_IND, MATERIAL_DETAIL_ID MATERIAL_DETAIL_ID, LOT_ID LOT_ID, QC_GRADE QC_GRADE, TRANS_ID TRANS_ID, SECONDARY_QTY SECONDARY_QTY, SECONDARY_UM SECONDARY_UM, WHSE_CODE WHSE_CODE, LOCATION LOCATION, BUFFER_IND BUFFER_IND, PLANT_CODE PLANT_CODE, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REVISION REVISION, SECONDARY_UOM SECONDARY_UOM, DETAIL_UOM DETAIL_UOM, GRADE_CODE GRADE_CODE, SUBINVENTORY_CODE SUBINVENTORY_CODE, LOT_NUMBER LOT_NUMBER, EXPIRATION_DATE EXPIRATION_DATE, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID, PLANT_ORGANIZATION_ID PLANT_ORGANIZATION_ID, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE, RESERVATION_ID RESERVATION_ID, TRANSACTION_ID TRANSACTION_ID, LOCATOR_ID LOCATOR_ID, PROD_PERCENT PROD_PERCENT from "GMD"."LM_SPRD_DTL"

View Text - HTML Formatted

SELECT LINE_ID LINE_ID
, LAB_TYPE LAB_TYPE
, SPRD_ID SPRD_ID
, LINE_TYPE LINE_TYPE
, LINE_NO LINE_NO
, ITEM_ID ITEM_ID
, QTY QTY
, ITEM_UM ITEM_UM
, TEXT_CODE TEXT_CODE
, TPFORMULA_ID TPFORMULA_ID
, FORMULALINE_ID FORMULALINE_ID
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ORGN_CODE ORGN_CODE
, ROLLUP_IND ROLLUP_IND
, MATERIAL_DETAIL_ID MATERIAL_DETAIL_ID
, LOT_ID LOT_ID
, QC_GRADE QC_GRADE
, TRANS_ID TRANS_ID
, SECONDARY_QTY SECONDARY_QTY
, SECONDARY_UM SECONDARY_UM
, WHSE_CODE WHSE_CODE
, LOCATION LOCATION
, BUFFER_IND BUFFER_IND
, PLANT_CODE PLANT_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REVISION REVISION
, SECONDARY_UOM SECONDARY_UOM
, DETAIL_UOM DETAIL_UOM
, GRADE_CODE GRADE_CODE
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, LOT_NUMBER LOT_NUMBER
, EXPIRATION_DATE EXPIRATION_DATE
, MOVE_ORDER_LINE_ID MOVE_ORDER_LINE_ID
, PLANT_ORGANIZATION_ID PLANT_ORGANIZATION_ID
, REVISION_QTY_CONTROL_CODE REVISION_QTY_CONTROL_CODE
, RESERVATION_ID RESERVATION_ID
, TRANSACTION_ID TRANSACTION_ID
, LOCATOR_ID LOCATOR_ID
, PROD_PERCENT PROD_PERCENT
FROM "GMD"."LM_SPRD_DTL"