APPS.ASO_PRICING_CORE_PVT dependencies on QP_LIST_LINES

Line 452: QP_LIST_LINES B

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
456: AND p_quote_header_id <> FND_API.G_MISS_NUM)

Line 472: QP_LIST_LINES B,

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)
476: AND (p_quote_header_id IS NOT NULL

Line 496: QP_LIST_LINES B

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
500: AND p_quote_header_id <> FND_API.G_MISS_NUM)

Line 517: QP_LIST_LINES B,

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)
521: AND (p_quote_header_id IS NOT NULL

Line 962: QP_LIST_LINES B

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
966: AND lines.line_id <> FND_API.G_MISS_NUM)

Line 982: QP_LIST_LINES B

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
986: AND lines.line_id <> FND_API.G_MISS_NUM)

Line 1003: QP_LIST_LINES B,

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)
1007: AND (lines.line_id IS NOT NULL

Line 1051: QP_LIST_LINES B,

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)
1055: AND (lines.line_id IS NOT NULL