Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GMD_TECHNICAL_SEQUENCE_VL |
SELECT H.TECH_SEQ_ID
, B.TECH_PARM_ID
, H.ORGN_CODE
, H.ITEM_ID
, H.CATEGORY_ID
, B.TECH_PARM_NAME
, D.SORT_SEQ
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATE_LOGIN
, H.ORGN_CODE
, H.TEXT_CODE
, NULL
, H.DELETE_MARK
, H.INVENTORY_ITEM_ID
, H.ORGANIZATION_ID
FROM GMD_TECHNICAL_SEQUENCE_HDR H
, GMD_TECHNICAL_SEQUENCE_DTL D
, GMD_TECH_PARAMETERS_B B
WHERE H.TECH_SEQ_ID = D.TECH_SEQ_ID
AND D.TECH_PARM_ID = B.TECH_PARM_ID
AND H.DELETE_MARK = 0