APPS.OE_ADV_PRICE_PVT dependencies on QP_LDETS_V

Line 261: FROM QP_LDETS_V ldets,

257: IS
258:
259: Cursor upgraded_items IS
260: SELECT ldets.line_detail_index,ldets.Line_index,ldets.related_item_id,lines.line_id
261: FROM QP_LDETS_V ldets,
262: QP_PREQ_LINES_TMP lines
263: WHERE ldets.list_line_Type_code /*created_from_list_line_type list_line_Type_code*/= 'IUE'
264: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,
265: QP_PREQ_PUB.G_STATUS_UPDATED)

Line 286: from qp_ldets_v where process_code

282: and price_flag IN ('Y','P')
283: and process_status <> 'NOT_VALID'
284: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
285: /* AND list_line_id NOT IN (SELECT list_line_id
286: from qp_ldets_v where process_code
287: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and line_index=adj.line_id+oe_order_cache.g_header_rec.header_id)*/
288: AND list_line_id NOT IN (SELECT list_line_id
289: from qp_ldets_v ld, qp_preq_lines_tmp l
290: where ld.process_code

Line 289: from qp_ldets_v ld, qp_preq_lines_tmp l

285: /* AND list_line_id NOT IN (SELECT list_line_id
286: from qp_ldets_v where process_code
287: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and line_index=adj.line_id+oe_order_cache.g_header_rec.header_id)*/
288: AND list_line_id NOT IN (SELECT list_line_id
289: from qp_ldets_v ld, qp_preq_lines_tmp l
290: where ld.process_code
291: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
292: and l.line_id = adj.line_id);
293:

Line 549: QP_LDETS_v ldets

545: , NULL
546: , NULL
547: , 1
548: FROM
549: QP_LDETS_v ldets
550: , QP_LIST_HEADERS_B QH
551: WHERE
552: ldets.line_detail_index = i.line_detail_index
553: and ldets.list_header_id=qh.list_header_id

Line 595: FROM QP_LDETS_V

591: CREATED_FROM_LIST_LINE_TYPE = 'TSN';
592: Cursor test is
593: select Line_index,substitution_attribute,substitution_value_to,
594: process_code
595: FROM QP_LDETS_V
596: WHERE list_line_type_code = 'TSN';
597: Cursor new_terms IS
598: SELECT ldets.Line_index, ldets.line_detail_index, lines.line_id --bug 4190357 added line_detail_index
599: , ldets.substitution_attribute, ldets.substitution_value_to

Line 602: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

598: SELECT ldets.Line_index, ldets.line_detail_index, lines.line_id --bug 4190357 added line_detail_index
599: , ldets.substitution_attribute, ldets.substitution_value_to
600: ,CHANGE_REASON_CODE,CHANGE_REASON_TEXT
601: ,lines.line_type_code --bug 4190357
602: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
603: WHERE ldets.list_line_type_code = 'TSN'
604: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW
605: , QP_PREQ_PUB.G_STATUS_UPDATED
606: )

Line 967: QP_LDETS_v ldets

963: , NULL
964: , NULL
965: , 1
966: FROM
967: QP_LDETS_v ldets
968: , QP_LIST_HEADERS_B QH
969: WHERE
970: ldets.line_detail_index = i.line_detail_index
971: and ldets.list_header_id=qh.list_header_id

Line 1134: ,QP_LDETS_V LDET

1130: SELECT QH.NAME, LDET.LIST_LINE_NO
1131: INTO l_modifier
1132: , l_list_line_no
1133: FROM QP_PREQ_RLTD_LINES_TMP RLTD
1134: ,QP_LDETS_V LDET
1135: , QP_LIST_HEADERS_TL QH
1136: WHERE RLTD.RELATED_LINE_INDEX = p_line_index
1137: AND RLTD.RELATIONSHIP_TYPE_CODE = 'GENERATED_LINE'
1138: AND RLTD.LINE_DETAIL_INDEX = LDET.LINE_DETAIL_INDEX

Line 1632: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

1628: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
1629:
1630: Cursor limit_violated_details IS
1631: SELECT ldets.line_index, ldets.limit_text, lines.line_id
1632: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
1633: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
1634: AND ldets.line_index = lines.line_index;
1635: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
1636: l_Header_id number := oe_order_cache.g_header_rec.Header_id;

Line 1850: QP_LDETS_v ldets

1846: pricing_group_sequence,print_on_invoice_flag,
1847: price_break_type_code, substitution_attribute,
1848: proration_type_code, include_on_returns_flag,lines.line_index line_index
1849: from
1850: QP_LDETS_v ldets
1851: , QP_PREQ_LINES_TMP lines
1852: , QP_LIST_HEADERS_B QH
1853: where
1854: ldets.LIST_HEADER_ID = qh.list_header_id

Line 2419: QP_LDETS_v ldets

2415: , ldets.OPERAND_value
2416: , ldets.adjustment_amount
2417: , 1
2418: FROM
2419: QP_LDETS_v ldets
2420: , QP_PREQ_LINES_TMP lines
2421: , QP_LIST_HEADERS_B QH
2422: WHERE
2423: ldets.list_header_id=qh.list_header_id