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.GML_OPM_OM_CONV_MIG_PKG dependencies on IC_TXN_REQUEST_LINES

Line 42: l_mo_line_rec ic_txn_request_lines%rowtype;

38: l_return_status VARCHAR2(1);
39: l_IC$DEFAULT_LOCT VARCHAR2(255)DEFAULT NVL(FND_PROFILE.VALUE('IC$DEFAULT_LOCT'),' ') ;
40:
41: l_wdd_rec wsh_delivery_details%rowtype;
42: l_mo_line_rec ic_txn_request_lines%rowtype;
43: l_order_line oe_order_lines_all%rowtype;
44: l_ic_mo_header_rec ic_txn_request_headers%rowtype;
45: l_mtl_mo_header_rec INV_Move_Order_PUB.Trohdr_Rec_Type := INV_Move_Order_PUB.G_MISS_TROHDR_REC;
46: l_mtl_mo_line_rec INV_Move_Order_PUB.Trolin_Rec_Type; /*(:= INV_Move_Order_PUB.G_MISS_TROLIN_TBL; */

Line 183: FROM ic_txn_request_lines

179: AND lot_id = p_lot_id;
180:
181: CURSOR Get_Mo_Line(p_line_id IN NUMBER) IS
182: SELECT *
183: FROM ic_txn_request_lines
184: WHERE txn_source_line_id = p_line_id
185: AND line_status = 7; -- 7 is open , 5 is closed , 9 is cancelled
186:
187: CURSOR get_delivery_details(p_mo_line_id IN NUMBER, p_line_id IN NUMBER) IS

Line 196: ic_txn_request_lines l

192:
193: CURSOR get_move_order_header(p_line_id IN NUMBER) IS
194: SELECT h.*
195: FROM ic_txn_request_headers h,
196: ic_txn_request_lines l
197: WHERE l.header_id = h.header_id
198: AND l.line_id = p_line_id;
199:
200: CURSOR Cur_get_sch_sta_code(p_line_id IN NUMBER) IS

Line 349: UPDATE ic_txn_request_lines

345:
346: -- update any OPM mo lines with new org id so that new id will be used for migration down below -- 5731584
347: -- 5731584 start
348:
349: UPDATE ic_txn_request_lines
350: SET organization_id = l_organization_id
351: WHERE txn_source_line_id = open_order_line_rec.line_id
352: AND line_status = 7;
353: -- 5731584 end

Line 729: GMI_RESERVATION_UTIL.PrintLn('In move_order_line_rec cursor and this is an inventory item - Sales Order line_id : ic_txn_request_lines line id '|| to_char(open_order_line_rec.line_id)||':'||to_char(move_order_line_rec.line_id));

725:
726: IF l_opm_noninv_ind = 0 THEN -- -- 5475003 rework 10/19 - only create Move Orders if an inventory item (control from ic_item_mst)
727: /* - we do not create move orders for a non-inventory item in R12 (in 11i OPM we did ) */
728:
729: GMI_RESERVATION_UTIL.PrintLn('In move_order_line_rec cursor and this is an inventory item - Sales Order line_id : ic_txn_request_lines line id '|| to_char(open_order_line_rec.line_id)||':'||to_char(move_order_line_rec.line_id));
730:
731: /* Look for the move order header, has an mtl move order header been created for this already? */
732: OPEN get_move_order_header (move_order_line_rec.line_id);
733: FETCH get_move_order_header INTO l_ic_mo_header_rec;

Line 848: GMI_RESERVATION_UTIL.PrintLn(' Now for lines - ic_txn_request_lines attribute15: '||move_order_line_rec.attribute15);

844:
845: END IF; -- IF(l_ic_mo_header_rec.attribute15 IS NOT NULL) THEN
846:
847: /* Now Create a line */
848: GMI_RESERVATION_UTIL.PrintLn(' Now for lines - ic_txn_request_lines attribute15: '||move_order_line_rec.attribute15);
849:
850: IF(move_order_line_rec.attribute15 IS NOT NULL) THEN
851: l_mo_line_id := to_number(move_order_line_rec.attribute15);
852:

Line 856: GMI_RESERVATION_UTIL.PrintLn('ic_txn_request_lines attribute15 = null ');

852:
853: ELSE /* Create a move order line */
854:
855: GMI_RESERVATION_UTIL.PrintLn('debug messages start for create move order line ********************************');
856: GMI_RESERVATION_UTIL.PrintLn('ic_txn_request_lines attribute15 = null ');
857: GMI_RESERVATION_UTIL.PrintLn('l_trohdr_rec.header_id : '|| l_trohdr_rec.header_id);
858: GMI_RESERVATION_UTIL.PrintLn('l_mo_header_id : '|| l_mo_header_id);
859: GMI_RESERVATION_UTIL.PrintLn('from_subinventory_code : '|| move_order_line_rec.from_subinventory_code);
860: GMI_RESERVATION_UTIL.PrintLn('inventory_item_id : '|| move_order_line_rec.inventory_item_id);

Line 995: GMI_RESERVATION_UTIL.PrintLn(' before update of ic_txn_request_lines to attribute15 to line: '||to_char(l_mo_line_id));

991: /* Update OPM move order line attribute15 */
992:
993: l_mo_line_id := l_trolin_tbl(l_order_count).line_id;
994:
995: GMI_RESERVATION_UTIL.PrintLn(' before update of ic_txn_request_lines to attribute15 to line: '||to_char(l_mo_line_id));
996:
997: UPDATE ic_txn_request_lines
998: SET attribute15 = to_char(l_trolin_tbl(l_order_count).line_id)
999: WHERE line_id = move_order_line_rec.line_id;

Line 997: UPDATE ic_txn_request_lines

993: l_mo_line_id := l_trolin_tbl(l_order_count).line_id;
994:
995: GMI_RESERVATION_UTIL.PrintLn(' before update of ic_txn_request_lines to attribute15 to line: '||to_char(l_mo_line_id));
996:
997: UPDATE ic_txn_request_lines
998: SET attribute15 = to_char(l_trolin_tbl(l_order_count).line_id)
999: WHERE line_id = move_order_line_rec.line_id;
1000:
1001: GMI_RESERVATION_UTIL.PrintLn(' after update to ic_txn_request_lines to attribute15 to line: '||to_char(l_mo_line_id));

Line 1001: GMI_RESERVATION_UTIL.PrintLn(' after update to ic_txn_request_lines to attribute15 to line: '||to_char(l_mo_line_id));

997: UPDATE ic_txn_request_lines
998: SET attribute15 = to_char(l_trolin_tbl(l_order_count).line_id)
999: WHERE line_id = move_order_line_rec.line_id;
1000:
1001: GMI_RESERVATION_UTIL.PrintLn(' after update to ic_txn_request_lines to attribute15 to line: '||to_char(l_mo_line_id));
1002:
1003: l_line_id := l_trolin_tbl(l_order_count).line_id;
1004: -- 5601081 rework
1005: -- need to populate to_locator_id as Create_move_order_line API

Line 1034: GMI_RESERVATION_UTIL.PrintLn(' in loop to update wsh_delivery_detail old ic_txn_request_lines line_id '||to_char(move_order_line_rec.line_id));

1030:
1031: FOR delivery_detail_rec IN get_delivery_details(move_order_line_rec.line_id,open_order_line_rec.line_id)
1032: LOOP
1033: GMI_RESERVATION_UTIL.PrintLn(' in loop to update wsh_delivery_detail delivery_detail_rec.delivery_detail_id '||to_char(delivery_detail_rec.delivery_detail_id));
1034: GMI_RESERVATION_UTIL.PrintLn(' in loop to update wsh_delivery_detail old ic_txn_request_lines line_id '||to_char(move_order_line_rec.line_id));
1035: GMI_RESERVATION_UTIL.PrintLn(' in loop to update wsh_delivery_detail open_order_line_rec.line_id '||to_char(open_order_line_rec.line_id));
1036: GMI_RESERVATION_UTIL.PrintLn(' in loop to update wsh_delivery_detail l_opm_noninv_ind '||to_char(l_opm_noninv_ind ));
1037:
1038: -- if non_inv item need to set dd to staged 5475003