APPS.ASO_PRICING_CORE_PVT dependencies on QP_LIST_LINES

Line 467: QP_LIST_LINES B

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

Line 487: QP_LIST_LINES B,

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

Line 511: QP_LIST_LINES B

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

Line 532: QP_LIST_LINES B,

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

Line 977: QP_LIST_LINES B

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

Line 997: QP_LIST_LINES B

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

Line 1018: QP_LIST_LINES B,

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

Line 1066: QP_LIST_LINES B,

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