DBA Data[Home] [Help]

APPS.QP_BULK_VALUE_TO_ID dependencies on QP_PRICE_FORMULAS_VL

Line 262: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c

258: SET(PRICE_BY_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
259: (SELECT b.PRICE_FORMULA_ID,
260: DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
261: DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'001', a.ATTRIBUTE_STATUS)
262: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c
263: WHERE c.PRICE_BY_FORMULA = b.NAME(+)
264: AND a.rowid = c.rowid
265: )
266: WHERE a.REQUEST_ID = P_REQUEST_ID

Line 280: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c

276: SET(GENERATE_USING_FORMULA_ID, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
277: (SELECT b.PRICE_FORMULA_ID,
278: DECODE(b.PRICE_FORMULA_ID, NULL, null, 'P'),
279: DECODE(b.PRICE_FORMULA_ID,NULL, a.ATTRIBUTE_STATUS||'002', a.ATTRIBUTE_STATUS)
280: FROM QP_PRICE_FORMULAS_VL b, QP_INTERFACE_LIST_LINES c
281: WHERE c.GENERATE_USING_FORMULA = b.NAME(+)
282: AND a.rowid = c.rowid
283: )
284: WHERE a.REQUEST_ID = P_REQUEST_ID