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 31080: --qp_preq_line_attrs_formula_tmp with relevant records from

31076: LOOP
31077: l_line_index := i.line_index;
31078:
31079: -- performance related change. Populate the temp table
31080: --qp_preq_line_attrs_formula_tmp with relevant records from
31081: --qp_npreq_line_attrs_tmp with
31082: IF l_get_formula_id_cur%ROWCOUNT = 1 THEN
31083:
31084: IF G_INSERT_INTO_FORMULA_TMP

Line 31088: DELETE FROM qp_preq_line_attrs_formula_tmp;

31084: IF G_INSERT_INTO_FORMULA_TMP
31085: THEN
31086:
31087: --Delete already existing rows from formula tmp table
31088: DELETE FROM qp_preq_line_attrs_formula_tmp;
31089:
31090: --Insert request line attrs with datatype = 'N'
31091: IF G_AM_INSTALLED_PROFILE = G_YES THEN
31092: If nvl(l_pass_qualifiers, 'N') = 'N' Then /* Bug 2772214 */

Line 31113: INSERT INTO qp_preq_line_attrs_formula_tmp

31109: --Change flexible mask to mask below for formula pattern use.
31110: qp_number.canonical_mask :=
31111: '00999999999999999999999.99999999999999999999999999999999999999';
31112: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
31113: INSERT INTO qp_preq_line_attrs_formula_tmp
31114: ( line_index,
31115: attribute_type,
31116: context,
31117: attribute,

Line 31157: INSERT INTO qp_preq_line_attrs_formula_tmp

31153: --Change flexible mask to mask below for formula pattern use.
31154: qp_number.canonical_mask :=
31155: '00999999999999999999999.99999999999999999999999999999999999999';
31156: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
31157: INSERT INTO qp_preq_line_attrs_formula_tmp
31158: ( line_index,
31159: attribute_type,
31160: context,
31161: attribute,

Line 31205: INSERT INTO qp_preq_line_attrs_formula_tmp

31201: '00999999999999999999999.99999999999999999999999999999999999999';
31202:
31203: -- Bug 2772214 l_pass_qualifiers condition in where clause
31204: --Insert request line attrs with datatype 'X', 'Y', 'C' or null
31205: INSERT INTO qp_preq_line_attrs_formula_tmp
31206: ( line_index,
31207: attribute_type,
31208: context,
31209: attribute,

Line 31265: INSERT INTO qp_preq_line_attrs_formula_tmp

31261: qp_number.canonical_mask :=
31262: '00999999999999999999999.99999999999999999999999999999999999999';
31263:
31264: FORALL i IN l_line_index_tbl.FIRST..l_line_index_tbl.LAST
31265: INSERT INTO qp_preq_line_attrs_formula_tmp
31266: ( line_index,
31267: attribute_type,
31268: context,
31269: attribute,

Line 31295: INSERT INTO qp_preq_line_attrs_formula_tmp

31291: qp_number.canonical_mask :=
31292: '00999999999999999999999.99999999999999999999999999999999999999';
31293:
31294: --Insert request line attrs with datatype 'X', 'Y', 'C' or null
31295: INSERT INTO qp_preq_line_attrs_formula_tmp
31296: ( line_index,
31297: attribute_type,
31298: context,
31299: attribute,

Line 31342: DELETE FROM qp_preq_line_attrs_formula_tmp

31338: -- FTE
31339:
31340: -- Delete for every modifier
31341: IF(l_attr_inserted_flag = TRUE) THEN
31342: DELETE FROM qp_preq_line_attrs_formula_tmp
31343: WHERE line_index = i.line_index
31344: AND context = 'VOLUME'
31345: AND attribute IN ('PRICING_ATTRIBUTE4','PRICING_ATTRIBUTE5')
31346: AND pricing_status_code = G_STATUS_UNCHANGED;

Line 31357: INSERT INTO qp_preq_line_attrs_formula_tmp

31353:
31354: --Change flexible mask to mask below for formula pattern use.
31355: qp_number.canonical_mask :=
31356: '00999999999999999999999.99999999999999999999999999999999999999';
31357: INSERT INTO qp_preq_line_attrs_formula_tmp
31358: ( line_index,
31359: attribute_type,
31360: context,
31361: attribute,

Line 31387: INSERT INTO qp_preq_line_attrs_formula_tmp

31383:
31384: --Change flexible mask to mask below for formula pattern use.
31385: qp_number.canonical_mask :=
31386: '00999999999999999999999.99999999999999999999999999999999999999';
31387: INSERT INTO qp_preq_line_attrs_formula_tmp
31388: ( line_index,
31389: attribute_type,
31390: context,
31391: attribute,

Line 31621: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;

31617: --Delete From qp_npreq_ldets_tmp;
31618: --Delete From qp_npreq_rltd_lines_tmp;
31619: --Delete From QP_PREQ_QUAL_TMP;
31620: --Delete From qp_nformula_step_values_tmp;
31621: --Delete From QP_PREQ_LINE_ATTRS_FORMULA_TMP;
31622:
31623:
31624: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
31625: select count(*) into l_count from qp_npreq_lines_tmp;