VIEW: APPS.GMD_TECHNICAL_SEQUENCE_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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