VIEW: APPS.GMD_TECHNICAL_DATA_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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