VIEW: APPS.QP_QUALIFIERS_V

Source

View Text - Preformatted

SELECT q.rowid, q.qualifier_id, q.creation_date, q.created_by, q.last_update_date, q.last_updated_by, q.last_update_login, q.program_application_id, q.program_id, q.program_update_date, q.request_id, q.excluder_flag, q.comparison_operator_code, q.qualifier_context, q.qualifier_attribute, q.context, q.attribute1, q.attribute2, q.attribute3, q.attribute4, q.attribute5, q.attribute6, q.attribute7, q.attribute8, q.attribute9, q.attribute10, q.attribute11, q.attribute12, q.attribute13, q.attribute14, q.attribute15, q.qualifier_rule_id, q.qualifier_grouping_no, q.qualifier_attr_value, q.list_header_id, q.list_line_id, q.created_from_rule_id, q.start_date_active, q.end_date_active, q.qualifier_datatype, q.qualifier_precedence, q.qualifier_attr_value_to, r.name, r.description, q.QUALIFY_HIER_DESCENDENTS_FLAG FROM qp_qualifiers q, qp_qualifier_rules r WHERE q.created_from_rule_id = r.qualifier_rule_id(+)

View Text - HTML Formatted

SELECT Q.ROWID
, Q.QUALIFIER_ID
, Q.CREATION_DATE
, Q.CREATED_BY
, Q.LAST_UPDATE_DATE
, Q.LAST_UPDATED_BY
, Q.LAST_UPDATE_LOGIN
, Q.PROGRAM_APPLICATION_ID
, Q.PROGRAM_ID
, Q.PROGRAM_UPDATE_DATE
, Q.REQUEST_ID
, Q.EXCLUDER_FLAG
, Q.COMPARISON_OPERATOR_CODE
, Q.QUALIFIER_CONTEXT
, Q.QUALIFIER_ATTRIBUTE
, Q.CONTEXT
, Q.ATTRIBUTE1
, Q.ATTRIBUTE2
, Q.ATTRIBUTE3
, Q.ATTRIBUTE4
, Q.ATTRIBUTE5
, Q.ATTRIBUTE6
, Q.ATTRIBUTE7
, Q.ATTRIBUTE8
, Q.ATTRIBUTE9
, Q.ATTRIBUTE10
, Q.ATTRIBUTE11
, Q.ATTRIBUTE12
, Q.ATTRIBUTE13
, Q.ATTRIBUTE14
, Q.ATTRIBUTE15
, Q.QUALIFIER_RULE_ID
, Q.QUALIFIER_GROUPING_NO
, Q.QUALIFIER_ATTR_VALUE
, Q.LIST_HEADER_ID
, Q.LIST_LINE_ID
, Q.CREATED_FROM_RULE_ID
, Q.START_DATE_ACTIVE
, Q.END_DATE_ACTIVE
, Q.QUALIFIER_DATATYPE
, Q.QUALIFIER_PRECEDENCE
, Q.QUALIFIER_ATTR_VALUE_TO
, R.NAME
, R.DESCRIPTION
, Q.QUALIFY_HIER_DESCENDENTS_FLAG
FROM QP_QUALIFIERS Q
, QP_QUALIFIER_RULES R
WHERE Q.CREATED_FROM_RULE_ID = R.QUALIFIER_RULE_ID(+)