DBA Data[Home] [Help]

APPS.INV_MOVE_ORDER_PUB dependencies on MTL_TXN_REQUEST_HEADERS

Line 299: from mtl_txn_request_headers h

295: l_count NUMBER;
296:
297: CURSOR get_move_order_type (V_header_id NUMBER) IS
298: select move_order_type
299: from mtl_txn_request_headers h
300: where h.header_id = V_header_id;
301: -- 6689912
302: CURSOR get_sales_order (V_line_id NUMBER) IS
303: select h.order_number , l.org_id -- 6689912 added org_id

Line 311: l_move_order_type MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE%TYPE;

307: and l.line_id = V_line_id;
308:
309: l_org_id number; -- 6689912
310: l_order_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
311: l_move_order_type MTL_TXN_REQUEST_HEADERS.MOVE_ORDER_TYPE%TYPE;
312: l_error_code NUMBER;
313: l_msg_data VARCHAR2(240);
314:
315: CURSOR get_sub_loc_ctrl(v_org_id NUMBER, v_sub_code VARCHAR2) IS

Line 1135: from mtl_txn_request_headers

1131: and l_trolin_tbl(i).header_id <> FND_API.G_MISS_NUM ) then
1132: --inv_debug.message('check if the header_id exists');
1133: select count(*)
1134: into l_dummy
1135: from mtl_txn_request_headers
1136: where header_id = l_trolin_tbl(i).header_id
1137: and organization_id = l_trolin_tbl(i).organization_id;
1138: --inv_debug.message('l_dummy is ' || l_dummy);
1139: if( l_dummy = 0 ) then