DBA Data[Home] [Help]

APPS.IGS_EN_NSC_FILE_PRNT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 87

    SELECT pk_tbl.version
     FROM igs_en_attrib_values pk_tbl,
          igs_en_attrib_values ord_tbl
    WHERE pk_tbl.obj_type_id     = ord_tbl.obj_type_id (+)
          AND pk_tbl.obj_id      = ord_tbl.obj_id  (+)
          AND pk_tbl.version     = ord_tbl.version (+)
          AND pk_tbl.obj_id      = p_doc_inst_id
          AND pk_tbl.obj_type_id = p_obj_type_id
          AND pk_tbl.attrib_id   = c_pk_id
          AND ord_tbl.attrib_id  = c_ord_id
    ORDER BY ord_tbl.value;