APPS.ASO_PRICING_CORE_PVT dependencies on QP_PREQ_LINES_TMP_T

Line 465: FROM QP_PREQ_LINES_TMP_T lines,

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

Line 485: FROM QP_PREQ_LINES_TMP_T lines,

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

Line 509: FROM QP_PREQ_LINES_TMP_T lines,

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

Line 530: FROM QP_PREQ_LINES_TMP_T lines,

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

Line 975: FROM QP_PREQ_LINES_TMP_T lines,

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

Line 995: FROM QP_PREQ_LINES_TMP_T lines,

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

Line 1016: FROM QP_PREQ_LINES_TMP_T lines,

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

Line 1064: FROM QP_PREQ_LINES_TMP_T lines,

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