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_BLANKET_UTIL dependencies on OE_BLANKET_LINES_EXT

Line 683: UPDATE oe_blanket_lines_ext

679: lock_control = lock_control + 1
680: WHERE
681: line_id = g_line_id_tbl(K).line_id ;
682:
683: UPDATE oe_blanket_lines_ext
684: SET
685: qp_list_line_id = ppr_price_list_line_tbl(K).list_line_id
686: WHERE
687: line_id = g_line_id_tbl(K).line_id ;

Line 922: Update oe_blanket_lines_ext

918: WHERE
919: line_id =
920: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;
921:
922: Update oe_blanket_lines_ext
923: set qp_list_line_id = ppr_price_list_line_tbl(1).list_line_id
924: WHERE
925: line_id =
926: oe_delayed_requests_pvt.g_delayed_requests(I).entity_id ;

Line 1017: Update oe_blanket_lines_ext

1013: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016:
1017: Update oe_blanket_lines_ext
1018: set qp_list_line_id = Null
1019: WHERE line_id = oe_delayed_requests_pvt.g_delayed_requests(p_req_ind).entity_id ;
1020: END IF;
1021:

Line 3946: FROM OE_BLANKET_LINES_EXT

3942: BEGIN
3943:
3944: SELECT 'ERROR'
3945: INTO l_dummy
3946: FROM OE_BLANKET_LINES_EXT
3947: WHERE ORDER_NUMBER = p_header_rec.order_number
3948: AND END_DATE_ACTIVE > p_header_rec.end_date_active
3949: AND ROWNUM = 1;
3950:

Line 3995: FROM OE_BLANKET_LINES_EXT

3991: THEN
3992: BEGIN
3993: SELECT 'CASCADE'
3994: INTO l_dummy
3995: FROM OE_BLANKET_LINES_EXT
3996: WHERE ORDER_NUMBER = p_header_rec.order_number
3997: AND END_DATE_ACTIVE IS NULL
3998: AND ROWNUM = 1;
3999:

Line 4007: FROM OE_BLANKET_LINES_EXT OLX, OE_BLANKET_LINES OL

4003: --if cascading, check to see if minimum values are satisfied
4004: IF (p_header_rec.end_date_active <= trunc(sysdate)) THEN
4005: SELECT 'WARNING'
4006: INTO l_dummy
4007: FROM OE_BLANKET_LINES_EXT OLX, OE_BLANKET_LINES OL
4008: WHERE OLX.LINE_ID = OL.LINE_ID
4009: AND OLX.ORDER_NUMBER = p_header_rec.order_number
4010: AND END_DATE_ACTIVE IS NULL
4011: AND OVERRIDE_BLANKET_CONTROLS_FLAG = 'N'

Line 4620: UPDATE OE_BLANKET_LINES_EXT

4616: , default_discount_percent = p_header_rec.default_discount_percent
4617: , default_discount_amount = p_header_rec.default_discount_amount
4618: WHERE order_number = p_header_rec.order_number;
4619:
4620: UPDATE OE_BLANKET_LINES_EXT
4621: SET
4622: END_DATE_ACTIVE = p_header_rec.end_date_active
4623: WHERE order_number = p_header_rec.order_number
4624: AND END_DATE_ACTIVE IS NULL;

Line 4975: INSERT INTO OE_BLANKET_LINES_EXT

4971: , p_line_rec.transaction_phase_code -- hashraf pack J
4972: , p_line_rec.source_document_version_number
4973: );
4974:
4975: INSERT INTO OE_BLANKET_LINES_EXT
4976: ( START_DATE_ACTIVE
4977: , END_DATE_ACTIVE
4978: , MAX_RELEASE_AMOUNT
4979: , MIN_RELEASE_AMOUNT

Line 5155: UPDATE OE_BLANKET_LINES_EXT

5151: IF SQL%NOTFOUND THEN
5152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5153: END IF;
5154:
5155: UPDATE OE_BLANKET_LINES_EXT
5156: SET
5157: min_release_quantity = p_line_rec.min_release_quantity
5158: , max_release_quantity = p_line_rec.max_release_quantity
5159: , START_DATE_ACTIVE = p_line_rec.START_DATE_ACTIVE

Line 5276: DELETE FROM OE_BLANKET_LINES_EXT

5272: WHERE line_id = p_line_id;
5273:
5274: --for bug 3348870
5275:
5276: DELETE FROM OE_BLANKET_LINES_EXT
5277: WHERE line_id = p_line_id;
5278:
5279: DELETE FROM OE_BLANKET_LINES_HIST
5280: WHERE line_id = p_line_id;

Line 5876: FROM OE_BLANKET_LINES bl, OE_BLANKET_LINES_EXT blx

5872: , source_document_version_number
5873: -- 11i10 Pricing Changes
5874: , modifier_list_line_id
5875: , blx.qp_list_line_id
5876: FROM OE_BLANKET_LINES bl, OE_BLANKET_LINES_EXT blx
5877: WHERE bl.line_id = blx.line_id
5878: AND bl.sales_document_type_code = 'B'
5879: AND ( bl.line_id = p_line_id OR
5880: header_id = p_header_id) ;

Line 6538: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX

6534: FOR UPDATE NOWAIT;
6535:
6536: CURSOR c_blanket_lines IS
6537: SELECT /* MOAC_SQL_CHANGE */ bl.line_id, bl.lock_control
6538: FROM OE_BLANKET_LINES_ALL BL, OE_BLANKET_LINES_EXT BLX
6539: WHERE BL.LINE_ID = BLX.LINE_ID
6540: AND BLX.ORDER_NUMBER = l_blanket_id
6541: AND BL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
6542: AND BL.SALES_DOCUMENT_TYPE_CODE = 'B'

Line 6566: FROM OE_BLANKET_LINES_EXT

6562: l_is_line_lock_control := FALSE;
6563: ELSE
6564: SELECT ORDER_NUMBER
6565: INTO l_blanket_id
6566: FROM OE_BLANKET_LINES_EXT
6567: WHERE LINE_ID = p_blanket_line_id;
6568:
6569: l_is_line_lock_control := TRUE;
6570: END IF;

Line 7616: from OE_BLANKET_LINES L, OE_BLANKET_LINES_EXT LX

7612: --modified the following sql to check for uiqueness of
7613: -- (inventory_item_id,item_idenitfier_type,ordered_item_id) for bug6826787
7614:
7615: select count(1) into lcount
7616: from OE_BLANKET_LINES L, OE_BLANKET_LINES_EXT LX
7617: where L.line_id = LX.line_id
7618: AND L.header_id = l_header_id
7619: AND L.line_id <> l_line_id
7620: AND ( ( l_item_identifier_type NOT IN ('ALL','CAT')