eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PREQ_GRP dependencies on FND_NUMBER

Line 11199: fnd_number.canonical_to_number(c.value_from) group_value,

11195: p_attribute VARCHAR2,
11196: p_attribute_type VARCHAR2)
11197: IS
11198: SELECT /*+ ORDERED USE_NL(a) l_line_amount_cur */
11199: fnd_number.canonical_to_number(c.value_from) group_value,
11200: a.priced_quantity
11201: FROM qp_npreq_line_attrs_tmp c, qp_npreq_lines_tmp a
11202: WHERE a.line_index = p_line_index
11203: AND a.LINE_INDEX = c.LINE_INDEX

Line 39376: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))

39372: --AND a.MODIFIER_LEVEL_CODE <> G_LINE_GROUP
39373: AND NOT (NVL(a.MODIFIER_LEVEL_CODE,FND_API.G_MISS_CHAR) = G_LINE_GROUP
39374: AND a.CONTEXT = G_PRIC_VOLUME_CONTEXT
39375: AND a.attribute in (G_QUANTITY_ATTRIBUTE,G_LINE_AMT_ATTRIBUTE))
39376: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))
39377: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))
39378: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))
39379: AND a.grouping_number = -1);
39380:

Line 39377: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))

39373: AND NOT (NVL(a.MODIFIER_LEVEL_CODE,FND_API.G_MISS_CHAR) = G_LINE_GROUP
39374: AND a.CONTEXT = G_PRIC_VOLUME_CONTEXT
39375: AND a.attribute in (G_QUANTITY_ATTRIBUTE,G_LINE_AMT_ATTRIBUTE))
39376: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))
39377: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))
39378: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))
39379: AND a.grouping_number = -1);
39380:
39381: UPDATE QP_PREQ_PATRN_QUAL_TMP

Line 39378: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))

39374: AND a.CONTEXT = G_PRIC_VOLUME_CONTEXT
39375: AND a.attribute in (G_QUANTITY_ATTRIBUTE,G_LINE_AMT_ATTRIBUTE))
39376: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))
39377: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))
39378: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))
39379: AND a.grouping_number = -1);
39380:
39381: UPDATE QP_PREQ_PATRN_QUAL_TMP
39382: SET pricing_status_code = G_DEL_OTHR_OPR_GRP

Line 39420: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))

39416: --AND a.MODIFIER_LEVEL_CODE <> G_LINE_GROUP
39417: AND NOT (NVL(a.MODIFIER_LEVEL_CODE,FND_API.G_MISS_CHAR) = G_LINE_GROUP
39418: AND a.CONTEXT = G_PRIC_VOLUME_CONTEXT
39419: AND a.attribute in (G_QUANTITY_ATTRIBUTE,G_LINE_AMT_ATTRIBUTE))
39420: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))
39421: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))
39422: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))
39423: AND a.grouping_number <> -1);
39424:

Line 39421: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))

39417: AND NOT (NVL(a.MODIFIER_LEVEL_CODE,FND_API.G_MISS_CHAR) = G_LINE_GROUP
39418: AND a.CONTEXT = G_PRIC_VOLUME_CONTEXT
39419: AND a.attribute in (G_QUANTITY_ATTRIBUTE,G_LINE_AMT_ATTRIBUTE))
39420: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))
39421: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))
39422: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))
39423: AND a.grouping_number <> -1);
39424:
39425:

Line 39422: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))

39418: AND a.CONTEXT = G_PRIC_VOLUME_CONTEXT
39419: AND a.attribute in (G_QUANTITY_ATTRIBUTE,G_LINE_AMT_ATTRIBUTE))
39420: AND fnd_number.canonical_to_number(DECODE(datatype,QP_PREQ_GRP.G_NUMERIC,a.value_from,null))
39421: NOT BETWEEN nvl(fnd_number.canonical_to_number(a.setup_value_from),fnd_number.canonical_to_number(a.value_from))
39422: AND nvl(fnd_number.canonical_to_number(a.setup_value_to),fnd_number.canonical_to_number(a.value_from))
39423: AND a.grouping_number <> -1);
39424:
39425:
39426: IF qp_preq_grp.g_debug_engine = fnd_api.g_true THEN