eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ADV_PRICE_PVT dependencies on QP_LDETS_V

Line 306: FROM QP_LDETS_V ldets,

302: IS
303:
304: Cursor upgraded_items IS
305: SELECT ldets.line_detail_index,ldets.Line_index,ldets.related_item_id,lines.line_id
306: FROM QP_LDETS_V ldets,
307: QP_PREQ_LINES_TMP lines
308: WHERE ldets.list_line_Type_code /*created_from_list_line_type list_line_Type_code*/= 'IUE'
309: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW,
310: QP_PREQ_PUB.G_STATUS_UPDATED)

Line 332: from qp_ldets_v where process_code

328: and price_flag IN ('Y','P')
329: and process_status <> 'NOT_VALID'
330: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
331: /* AND list_line_id NOT IN (SELECT list_line_id
332: from qp_ldets_v where process_code
333: 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)*/
334: AND list_line_id NOT IN (SELECT list_line_id
335: from qp_ldets_v ld, qp_preq_lines_tmp l
336: where ld.process_code

Line 335: from qp_ldets_v ld, qp_preq_lines_tmp l

331: /* AND list_line_id NOT IN (SELECT list_line_id
332: from qp_ldets_v where process_code
333: 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)*/
334: AND list_line_id NOT IN (SELECT list_line_id
335: from qp_ldets_v ld, qp_preq_lines_tmp l
336: where ld.process_code
337: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
338: and l.line_id = adj.line_id);
339:

Line 617: QP_LDETS_v ldets

613: , NULL
614: , NULL
615: , 1
616: FROM
617: QP_LDETS_v ldets
618: , QP_LIST_HEADERS_B QH
619: WHERE
620: ldets.line_detail_index = i.line_detail_index
621: and ldets.list_header_id=qh.list_header_id

Line 664: FROM QP_LDETS_V

660: CREATED_FROM_LIST_LINE_TYPE = 'TSN';
661: Cursor test is
662: select Line_index,substitution_attribute,substitution_value_to,
663: process_code
664: FROM QP_LDETS_V
665: WHERE list_line_type_code = 'TSN';
666: Cursor new_terms IS
667: SELECT ldets.Line_index, ldets.line_detail_index, lines.line_id --bug 4190357 added line_detail_index
668: , ldets.substitution_attribute, ldets.substitution_value_to

Line 672: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

668: , ldets.substitution_attribute, ldets.substitution_value_to
669: ,CHANGE_REASON_CODE,CHANGE_REASON_TEXT
670: , MODIFIER_LEVEL_CODE --Bug 13573144
671: ,lines.line_type_code --bug 4190357
672: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
673: WHERE ldets.list_line_type_code = 'TSN'
674: AND ldets.process_code IN (QP_PREQ_PUB.G_STATUS_NEW
675: , QP_PREQ_PUB.G_STATUS_UPDATED
676: )

Line 697: from qp_ldets_v ld, qp_preq_lines_tmp l

693: and price_flag IN ('Y','P')
694: and process_status <> 'NOT_VALID'
695: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
696: AND adj.price_Adjustment_id NOT IN (SELECT ld.price_Adjustment_id
697: from qp_ldets_v ld, qp_preq_lines_tmp l
698: where ld.process_code
699: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
700: );
701:

Line 719: from qp_ldets_v ld, qp_preq_lines_tmp l

715: and price_flag IN ('Y','P')
716: and process_status <> 'NOT_VALID'
717: and pricing_status_code in (QP_PREQ_PUB.G_STATUS_UPDATED, QP_PREQ_PUB.G_STATUS_GSA_VIOLATION, QP_PREQ_PUB.G_STATUS_UNCHANGED))
718: AND adj.price_Adjustment_id NOT IN (SELECT price_Adjustment_id
719: from qp_ldets_v ld, qp_preq_lines_tmp l
720: where ld.process_code
721: IN (QP_PREQ_PUB.G_STATUS_UNCHANGED,QP_PREQ_PUB.G_STATUS_UPDATED) and l.line_index = ld.line_index
722: and l.line_type_code='ORDER' and l.line_id = adj.header_id);
723:

Line 1252: QP_LDETS_v ldets

1248: , NULL
1249: , NULL
1250: , 1
1251: FROM
1252: QP_LDETS_v ldets
1253: , QP_LIST_HEADERS_B QH
1254: WHERE
1255: ldets.line_detail_index = i.line_detail_index
1256: and ldets.list_header_id=qh.list_header_id

Line 1431: ,QP_LDETS_V LDET

1427: SELECT QH.NAME, LDET.LIST_LINE_NO
1428: INTO l_modifier
1429: , l_list_line_no
1430: FROM QP_PREQ_RLTD_LINES_TMP RLTD
1431: ,QP_LDETS_V LDET
1432: , QP_LIST_HEADERS_TL QH
1433: WHERE RLTD.RELATED_LINE_INDEX = p_line_index
1434: AND RLTD.RELATIONSHIP_TYPE_CODE = 'GENERATED_LINE'
1435: AND RLTD.LINE_DETAIL_INDEX = LDET.LINE_DETAIL_INDEX

Line 2059: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines

2055: WHERE HOLD_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_HOLD, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED);
2056:
2057: Cursor limit_violated_details IS
2058: SELECT ldets.line_index, ldets.limit_text, lines.line_id
2059: FROM QP_LDETS_V ldets, qp_preq_lines_tmp lines
2060: WHERE ldets.LIMIT_CODE IN (QP_PREQ_GRP.G_STATUS_LIMIT_EXCEEDED, QP_PREQ_GRP.G_STATUS_LIMIT_ADJUSTED )
2061: AND ldets.line_index = lines.line_index;
2062: l_limit_hold_action varchar2(30):=NVL(fnd_profile.value('ONT_PROMOTION_LIMIT_VIOLATION_ACTION'), 'NO_HOLD');
2063: l_Header_id number := oe_order_cache.g_header_rec.Header_id;

Line 2277: QP_LDETS_v ldets

2273: pricing_group_sequence,print_on_invoice_flag,
2274: price_break_type_code, substitution_attribute,
2275: proration_type_code, include_on_returns_flag,lines.line_index line_index
2276: from
2277: QP_LDETS_v ldets
2278: , QP_PREQ_LINES_TMP lines
2279: , QP_LIST_HEADERS_B QH
2280: where
2281: ldets.LIST_HEADER_ID = qh.list_header_id

Line 2887: QP_LDETS_v ldets

2883: , ldets.OPERAND_value
2884: , ldets.adjustment_amount
2885: , 1
2886: FROM
2887: QP_LDETS_v ldets
2888: , QP_PREQ_LINES_TMP lines
2889: , QP_LIST_HEADERS_B QH
2890: WHERE
2891: ldets.list_header_id=qh.list_header_id