APPS.ASO_PRICING_CORE_PVT dependencies on QP_PREQ_LINES_TMP_T

Line 450: FROM QP_PREQ_LINES_TMP_T lines,

446: B.SUBSTITUTION_VALUE,
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)

Line 470: FROM QP_PREQ_LINES_TMP_T lines,

466:
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

Line 494: FROM QP_PREQ_LINES_TMP_T lines,

490:
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)

Line 515: FROM QP_PREQ_LINES_TMP_T lines,

511:
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

Line 960: FROM QP_PREQ_LINES_TMP_T lines,

956: B.SUBSTITUTION_VALUE,
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)

Line 980: FROM QP_PREQ_LINES_TMP_T lines,

976:
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)

Line 1001: FROM QP_PREQ_LINES_TMP_T lines,

997:
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

Line 1049: FROM QP_PREQ_LINES_TMP_T lines,

1045:
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