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 QP_PREQ_LINE_ATTRS_FORMULA_TMP

Line 36658: --qp_preq_line_attrs_formula_tmp with relevant records from

36654: LOOP
36655: l_line_index := i.line_index;
36656:
36657: -- performance related change. Populate the temp table
36658: --qp_preq_line_attrs_formula_tmp with relevant records from
36659: --qp_npreq_line_attrs_tmp with
36660: IF l_get_formula_id_cur%ROWCOUNT = 1 THEN
36661:
36662: IF G_INSERT_INTO_FORMULA_TMP

Line 36666: DELETE FROM qp_preq_line_attrs_formula_tmp;

36662: IF G_INSERT_INTO_FORMULA_TMP
36663: THEN
36664:
36665: --Delete already existing rows from formula tmp table
36666: DELETE FROM qp_preq_line_attrs_formula_tmp;
36667:
36668: --Insert request line attrs with datatype = 'N'
36669: IF G_AM_INSTALLED_PROFILE = G_YES THEN
36670: If nvl(l_pass_qualifiers, 'N') = 'N' Then /* Bug 2772214 */

Line 36691: INSERT INTO qp_preq_line_attrs_formula_tmp

36687: --Change flexible mask to mask below for formula pattern use.
36688: qp_number.canonical_mask :=
36689: '00999999999999999999999.99999999999999999999999999999999999999';
36690: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
36691: INSERT INTO qp_preq_line_attrs_formula_tmp
36692: ( line_index,
36693: attribute_type,
36694: context,
36695: attribute,

Line 36735: INSERT INTO qp_preq_line_attrs_formula_tmp

36731: --Change flexible mask to mask below for formula pattern use.
36732: qp_number.canonical_mask :=
36733: '00999999999999999999999.99999999999999999999999999999999999999';
36734: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
36735: INSERT INTO qp_preq_line_attrs_formula_tmp
36736: ( line_index,
36737: attribute_type,
36738: context,
36739: attribute,

Line 36783: INSERT INTO qp_preq_line_attrs_formula_tmp

36779: '00999999999999999999999.99999999999999999999999999999999999999';
36780:
36781: -- Bug 2772214 l_pass_qualifiers condition in where clause
36782: --Insert request line attrs with datatype 'X', 'Y', 'C' or null
36783: INSERT INTO qp_preq_line_attrs_formula_tmp
36784: ( line_index,
36785: attribute_type,
36786: context,
36787: attribute,

Line 36843: INSERT INTO qp_preq_line_attrs_formula_tmp

36839: qp_number.canonical_mask :=
36840: '00999999999999999999999.99999999999999999999999999999999999999';
36841:
36842: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
36843: INSERT INTO qp_preq_line_attrs_formula_tmp
36844: ( line_index,
36845: attribute_type,
36846: context,
36847: attribute,

Line 36873: INSERT INTO qp_preq_line_attrs_formula_tmp

36869: qp_number.canonical_mask :=
36870: '00999999999999999999999.99999999999999999999999999999999999999';
36871:
36872: --Insert request line attrs with datatype 'X', 'Y', 'C' or null
36873: INSERT INTO qp_preq_line_attrs_formula_tmp
36874: ( line_index,
36875: attribute_type,
36876: context,
36877: attribute,

Line 36920: DELETE FROM qp_preq_line_attrs_formula_tmp

36916: -- FTE
36917:
36918: -- Delete for every modifier
36919: IF(l_attr_inserted_flag = TRUE) THEN
36920: DELETE FROM qp_preq_line_attrs_formula_tmp
36921: WHERE line_index = i.line_index
36922: AND context = 'VOLUME'
36923: AND attribute IN ('PRICING_ATTRIBUTE4','PRICING_ATTRIBUTE5')
36924: AND pricing_status_code = G_STATUS_UNCHANGED;

Line 36935: INSERT INTO qp_preq_line_attrs_formula_tmp

36931:
36932: --Change flexible mask to mask below for formula pattern use.
36933: qp_number.canonical_mask :=
36934: '00999999999999999999999.99999999999999999999999999999999999999';
36935: INSERT INTO qp_preq_line_attrs_formula_tmp
36936: ( line_index,
36937: attribute_type,
36938: context,
36939: attribute,

Line 36965: INSERT INTO qp_preq_line_attrs_formula_tmp

36961:
36962: --Change flexible mask to mask below for formula pattern use.
36963: qp_number.canonical_mask :=
36964: '00999999999999999999999.99999999999999999999999999999999999999';
36965: INSERT INTO qp_preq_line_attrs_formula_tmp
36966: ( line_index,
36967: attribute_type,
36968: context,
36969: attribute,

Line 37199: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;

37195: --Delete From qp_npreq_ldets_tmp;
37196: --Delete From qp_npreq_rltd_lines_tmp;
37197: --Delete From QP_PREQ_QUAL_TMP;
37198: --Delete From qp_nformula_step_values_tmp;
37199: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;
37200:
37201:
37202: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
37203: select count(*) into l_count from qp_npreq_lines_tmp;