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.

[Home] [Help]

APPS.ASO_PRICING_CORE_PVT dependencies on QP_PREQ_LDETS_TMP

Line 466: QP_PREQ_LDETS_TMP_T A,

462: b.substitution_attribute, lines.line_id,
463: lines.line_index, A.CREATED_FROM_LIST_LINE_TYPE,a.applied_flag,
464: a.modifier_level_code,a.process_code
465: FROM QP_PREQ_LINES_TMP_T lines,
466: QP_PREQ_LDETS_TMP_T A,
467: QP_LIST_LINES B
468: WHERE lines.line_id = p_quote_header_id
469: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
470: AND (p_quote_header_id IS NOT NULL

Line 486: QP_PREQ_LDETS_TMP_T A,

482: CURSOR c_hdr_pyt_tsn IS
483: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
484: B.SUBSTITUTION_VALUE
485: FROM QP_PREQ_LINES_TMP_T lines,
486: QP_PREQ_LDETS_TMP_T A,
487: QP_LIST_LINES B,
488: RA_TERMS_B ratv
489: WHERE lines.line_id = p_quote_header_id
490: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 510: QP_PREQ_LDETS_TMP_T A,

506: CURSOR c_hdr_smc_tsn IS
507: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
508: B.SUBSTITUTION_VALUE
509: FROM QP_PREQ_LINES_TMP_T lines,
510: QP_PREQ_LDETS_TMP_T A,
511: QP_LIST_LINES B
512: WHERE lines.line_id = p_quote_header_id
513: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
514: AND (p_quote_header_id IS NOT NULL

Line 531: QP_PREQ_LDETS_TMP_T A,

527: CURSOR c_hdr_ftc_tsn IS
528: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B olk) */
529: B.SUBSTITUTION_VALUE
530: FROM QP_PREQ_LINES_TMP_T lines,
531: QP_PREQ_LDETS_TMP_T A,
532: QP_LIST_LINES B,
533: fnd_lookup_values olk
534: WHERE lines.line_id = p_quote_header_id
535: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 976: QP_PREQ_LDETS_TMP_T A,

972: b.substitution_attribute, lines.line_id,
973: lines.line_index, A.CREATED_FROM_LIST_LINE_TYPE,a.applied_flag,
974: a.modifier_level_code,a.process_code
975: FROM QP_PREQ_LINES_TMP_T lines,
976: QP_PREQ_LDETS_TMP_T A,
977: QP_LIST_LINES B
978: WHERE lines.line_id = p_quote_line_id
979: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
980: AND (lines.line_id IS NOT NULL

Line 996: QP_PREQ_LDETS_TMP_T A,

992: CURSOR c_ln_smc_tsn (p_quote_line_id NUMBER) IS
993: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
994: B.SUBSTITUTION_VALUE
995: FROM QP_PREQ_LINES_TMP_T lines,
996: QP_PREQ_LDETS_TMP_T A,
997: QP_LIST_LINES B
998: WHERE lines.line_id = p_quote_line_id
999: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)
1000: AND (lines.line_id IS NOT NULL

Line 1017: QP_PREQ_LDETS_TMP_T A,

1013: CURSOR c_ln_ftc_tsn (p_quote_line_id NUMBER) IS
1014: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B olk) */
1015: B.SUBSTITUTION_VALUE
1016: FROM QP_PREQ_LINES_TMP_T lines,
1017: QP_PREQ_LDETS_TMP_T A,
1018: QP_LIST_LINES B,
1019: fnd_lookup_values olk
1020: WHERE lines.line_id = p_quote_line_id
1021: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 1065: QP_PREQ_LDETS_TMP_T A,

1061: CURSOR c_line_pyt_tsn(p_quote_line_id NUMBER) IS
1062: SELECT /*+ LEADING (lines) INDEX (lines, QP_PREQ_LINES_TMP_N1) USE_NL (lines A B ) */
1063: B.SUBSTITUTION_VALUE
1064: FROM QP_PREQ_LINES_TMP_T lines,
1065: QP_PREQ_LDETS_TMP_T A,
1066: QP_LIST_LINES B,
1067: RA_TERMS_B ratv
1068: WHERE lines.line_id = p_quote_line_id
1069: AND lines.REQUEST_ID = nvl(sys_context('QP_CONTEXT','REQUEST_ID'),1)

Line 9788: QP_PREQ_LDETS_TMP LDETS,

9784: 'QP_ATTR_DEFNS_PRICING')
9785: FROM
9786: ASO_PRICE_ADJUSTMENTS ADJ,
9787: QP_PREQ_LINES_TMP LINES ,
9788: QP_PREQ_LDETS_TMP LDETS,
9789: QP_PREQ_LINE_ATTRS_TMP QPLAT
9790: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9791: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
9792: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)

Line 9839: QP_PREQ_LDETS_TMP LDETS,

9835: 'QP_ATTR_DEFNS_PRICING')
9836: FROM
9837: ASO_PRICE_ADJUSTMENTS ADJ,
9838: QP_PREQ_LINES_TMP LINES ,
9839: QP_PREQ_LDETS_TMP LDETS,
9840: QP_PREQ_LINE_ATTRS_TMP QPLAT
9841: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
9842: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
9843: AND LDETS.LINE_INDEX = LINES.LINE_INDEX

Line 10106: QP_PREQ_LDETS_TMP LDETS,

10102: 'QP_ATTR_DEFNS_PRICING')
10103: FROM
10104: ASO_PRICE_ADJUSTMENTS ADJ,
10105: QP_PREQ_LINES_TMP LINES ,
10106: QP_PREQ_LDETS_TMP LDETS,
10107: QP_PREQ_LINE_ATTRS_TMP QPLAT
10108: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10109: AND LINES.LINE_ID = ADJ.QUOTE_LINE_ID
10110: AND lines.process_status IN (QP_PREQ_GRP.G_STATUS_UPDATED,QP_PREQ_GRP.G_STATUS_UNCHANGED)

Line 10272: QP_PREQ_LDETS_TMP LDETS,

10268: 'QP_ATTR_DEFNS_PRICING')
10269: FROM
10270: ASO_PRICE_ADJUSTMENTS ADJ,
10271: QP_PREQ_LINES_TMP LINES ,
10272: QP_PREQ_LDETS_TMP LDETS,
10273: QP_PREQ_LINE_ATTRS_TMP QPLAT
10274: WHERE ADJ.QUOTE_HEADER_ID = p_qte_header_rec.quote_header_id
10275: AND LINES.LINE_ID = ADJ.QUOTE_HEADER_ID
10276: AND LDETS.LINE_INDEX = LINES.LINE_INDEX