Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMD_TECHNICAL_DATA_VL |
SELECT H.TECH_DATA_ID
, H.ORGN_CODE
, H.ITEM_ID
, H.LOT_ID
, H.FORMULA_ID
, H.BATCH_ID
, B.TECH_PARM_ID
, B.TECH_PARM_NAME
, D.SORT_SEQ
, D.TEXT_DATA
, D.NUM_DATA
, D.BOOLEAN_DATA
, D.TEXT_CODE
, H.LOT_NUMBER
, H.INVENTORY_ITEM_ID
, H.ORGANIZATION_ID
, H.LOT_ORGANIZATION_ID
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATE_LOGIN
, H.ORGN_CODE
, H.DELETE_MARK
, NULL
FROM GMD_TECHNICAL_DATA_HDR H
, GMD_TECHNICAL_DATA_DTL D
, GMD_TECH_PARAMETERS_B B
WHERE H.TECH_DATA_ID = D.TECH_DATA_ID
AND D.TECH_PARM_ID = B.TECH_PARM_ID
AND H.DELETE_MARK = 0