APPS.ASO_PRICING_CORE_PVT dependencies on QP_PREQ_LDETS_TMP_T

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)