DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_QUALIFIER_RULES

Line 133: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c

129: SET(CREATED_FROM_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
130: (SELECT b.QUALIFIER_RULE_ID,
131: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
132: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)
133: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
134: WHERE c.CREATED_FROM_RULE = b.NAME(+)
135: AND a.rowid = c.rowid
136: )
137: WHERE a.REQUEST_ID = P_REQUEST_ID

Line 153: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c

149: SET(QUALIFIER_RULE_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
150: (SELECT b.QUALIFIER_RULE_ID,
151: DECODE(b.QUALIFIER_RULE_ID, NULL, null, 'P'),
152: DECODE(b.QUALIFIER_RULE_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)
153: FROM QP_QUALIFIER_RULES b, QP_INTERFACE_QUALIFIERS c
154: WHERE c.QUALIFIER_RULE = b.NAME(+)
155: AND a.rowid = c.rowid
156: )
157: WHERE a.REQUEST_ID = P_REQUEST_ID