DBA Data[Home] [Help]

APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on OE_ORDER_LINES_ALL

Line 43: l_order_line oe_order_lines_all%rowtype;

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; */
47:

Line 120: FROM oe_order_lines_all ol,

116: ship_from_org_id,
117: schedule_status_code,
118: 'OE' source,
119: ordered_quantity qty -- added for debug only
120: FROM oe_order_lines_all ol,
121: mtl_parameters mtl
122: WHERE ol.ship_from_org_id = mtl.organization_id
123: AND mtl.process_enabled_flag = 'Y' AND
124: NVL(ol.shipping_interfaced_flag,'N')= 'N'

Line 202: FROM oe_order_lines_all

198: AND l.line_id = p_line_id;
199:
200: CURSOR Cur_get_sch_sta_code(p_line_id IN NUMBER) IS
201: SELECT schedule_status_code
202: FROM oe_order_lines_all
203: WHERE line_id = p_line_id;
204:
205:
206: --5574631

Line 341: UPDATE oe_order_lines_all

337:
338: /* need to update the SO line with new org (open_order_line_rec.ship_from_org_id) */
339: GMI_RESERVATION_UTIL.PrintLn(' before update to ship_from_org_id of so line '|| open_order_line_rec.line_id);
340:
341: UPDATE oe_order_lines_all
342: SET ship_from_org_id = l_organization_id
343: WHERE line_id = open_order_line_rec.line_id;
344:
345: