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.ASO_PRICING_CORE_PVT dependencies on QP_PREQ_LDETS_TMP

Line 451: QP_PREQ_LDETS_TMP_T A,

447: b.substitution_attribute, lines.line_id,
448: lines.line_index, A.CREATED_FROM_LIST_LINE_TYPE,a.applied_flag,
449: a.modifier_level_code,a.process_code
450: FROM QP_PREQ_LINES_TMP_T lines,
451: QP_PREQ_LDETS_TMP_T A,
452: QP_LIST_LINES B
453: WHERE lines.line_id = p_quote_header_id
454: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
455: AND (p_quote_header_id IS NOT NULL

Line 471: QP_PREQ_LDETS_TMP_T A,

467: CURSOR c_hdr_pyt_tsn IS
468: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
469: B.SUBSTITUTION_VALUE
470: FROM QP_PREQ_LINES_TMP_T lines,
471: QP_PREQ_LDETS_TMP_T A,
472: QP_LIST_LINES B,
473: RA_TERMS_B ratv
474: WHERE lines.line_id = p_quote_header_id
475: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 495: QP_PREQ_LDETS_TMP_T A,

491: CURSOR c_hdr_smc_tsn IS
492: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
493: B.SUBSTITUTION_VALUE
494: FROM QP_PREQ_LINES_TMP_T lines,
495: QP_PREQ_LDETS_TMP_T A,
496: QP_LIST_LINES B
497: WHERE lines.line_id = p_quote_header_id
498: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
499: AND (p_quote_header_id IS NOT NULL

Line 516: QP_PREQ_LDETS_TMP_T A,

512: CURSOR c_hdr_ftc_tsn IS
513: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B olk) */
514: B.SUBSTITUTION_VALUE
515: FROM QP_PREQ_LINES_TMP_T lines,
516: QP_PREQ_LDETS_TMP_T A,
517: QP_LIST_LINES B,
518: fnd_lookup_values olk
519: WHERE lines.line_id = p_quote_header_id
520: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 961: QP_PREQ_LDETS_TMP_T A,

957: b.substitution_attribute, lines.line_id,
958: lines.line_index, A.CREATED_FROM_LIST_LINE_TYPE,a.applied_flag,
959: a.modifier_level_code,a.process_code
960: FROM QP_PREQ_LINES_TMP_T lines,
961: QP_PREQ_LDETS_TMP_T A,
962: QP_LIST_LINES B
963: WHERE lines.line_id = p_quote_line_id
964: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
965: AND (lines.line_id IS NOT NULL

Line 981: QP_PREQ_LDETS_TMP_T A,

977: CURSOR c_ln_smc_tsn (p_quote_line_id NUMBER) IS
978: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
979: B.SUBSTITUTION_VALUE
980: FROM QP_PREQ_LINES_TMP_T lines,
981: QP_PREQ_LDETS_TMP_T A,
982: QP_LIST_LINES B
983: WHERE lines.line_id = p_quote_line_id
984: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
985: AND (lines.line_id IS NOT NULL

Line 1002: QP_PREQ_LDETS_TMP_T A,

998: CURSOR c_ln_ftc_tsn (p_quote_line_id NUMBER) IS
999: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B olk) */
1000: B.SUBSTITUTION_VALUE
1001: FROM QP_PREQ_LINES_TMP_T lines,
1002: QP_PREQ_LDETS_TMP_T A,
1003: QP_LIST_LINES B,
1004: fnd_lookup_values olk
1005: WHERE lines.line_id = p_quote_line_id
1006: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 1050: QP_PREQ_LDETS_TMP_T A,

1046: CURSOR c_line_pyt_tsn(p_quote_line_id NUMBER) IS
1047: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
1048: B.SUBSTITUTION_VALUE
1049: FROM QP_PREQ_LINES_TMP_T lines,
1050: QP_PREQ_LDETS_TMP_T A,
1051: QP_LIST_LINES B,
1052: RA_TERMS_B ratv
1053: WHERE lines.line_id = p_quote_line_id
1054: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 9771: QP_PREQ_LDETS_TMP LDETS,

9767: 'QP_ATTR_DEFNS_PRICING')
9768: FROM
9769: ASO_PRICE_ADJUSTMENTS ADJ,
9770: QP_PREQ_LINES_TMP LINES ,
9771: QP_PREQ_LDETS_TMP LDETS,
9772: QP_PREQ_LINE_ATTRS_TMP QPLAT
9773: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9774: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
9775: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)

Line 9822: QP_PREQ_LDETS_TMP LDETS,

9818: 'QP_ATTR_DEFNS_PRICING')
9819: FROM
9820: ASO_PRICE_ADJUSTMENTS ADJ,
9821: QP_PREQ_LINES_TMP LINES ,
9822: QP_PREQ_LDETS_TMP LDETS,
9823: QP_PREQ_LINE_ATTRS_TMP QPLAT
9824: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9825: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
9826: AND LDETS.LINE_INDEX = LINES.LINE_INDEX

Line 10089: QP_PREQ_LDETS_TMP LDETS,

10085: 'QP_ATTR_DEFNS_PRICING')
10086: FROM
10087: ASO_PRICE_ADJUSTMENTS ADJ,
10088: QP_PREQ_LINES_TMP LINES ,
10089: QP_PREQ_LDETS_TMP LDETS,
10090: QP_PREQ_LINE_ATTRS_TMP QPLAT
10091: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10092: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
10093: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)

Line 10255: QP_PREQ_LDETS_TMP LDETS,

10251: 'QP_ATTR_DEFNS_PRICING')
10252: FROM
10253: ASO_PRICE_ADJUSTMENTS ADJ,
10254: QP_PREQ_LINES_TMP LINES ,
10255: QP_PREQ_LDETS_TMP LDETS,
10256: QP_PREQ_LINE_ATTRS_TMP QPLAT
10257: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10258: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
10259: AND LDETS.LINE_INDEX = LINES.LINE_INDEX