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.ONT_ITM_PKG dependencies on WSH_ITM_ITEMS

Line 1239: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;

1235: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1239: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1241: END IF;
1242:
1243: -- BUG 5408161

Line 1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;

1236:
1237: IF l_debug_level > 0 THEN
1238: oe_debug_pub.add('Inserted record in to wsh_itm_request_control...' , 1 ) ;
1239: oe_debug_pub.add('WSH_ITM_ITEMS INVENTORY_ITEM_ID :'||p_line_rec.inventory_item_id , 1 ) ;
1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1241: END IF;
1242:
1243: -- BUG 5408161
1244: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)

Line 1244: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)

1240: oe_debug_pub.add('WSH_ITM_ITEMS ORGANIZATION_CODE :'||l_organization_code , 1 ) ;
1241: END IF;
1242:
1243: -- BUG 5408161
1244: -- Retrieve concatenated_segments ('ProductCode' in WSH_ITM_ITEMS table)
1245: SELECT concatenated_segments into l_product_code
1246: FROM mtl_system_items_vl
1247: WHERE inventory_item_id = p_line_rec.inventory_item_id
1248: AND organization_id = p_line_rec.ship_from_org_id; --l_organization_code ;

Line 1268: INSERT INTO WSH_ITM_ITEMS (

1264: WHEN OTHERS THEN
1265: l_Item_type := null;
1266: END;
1267:
1268: INSERT INTO WSH_ITM_ITEMS (
1269: ITEM_ID,
1270: REQUEST_CONTROL_ID,
1271: INVENTORY_ITEM_ID,
1272: ORGANIZATION_CODE,

Line 1283: wsh_itm_items_s.NEXTVAL,

1279: LAST_UPDATE_DATE,
1280: LAST_UPDATE_LOGIN
1281: )
1282: VALUES (
1283: wsh_itm_items_s.NEXTVAL,
1284: l_request_control_id,
1285: p_line_rec.inventory_item_id,
1286: l_organization_code,
1287: p_line_rec.org_id,

Line 1298: oe_debug_pub.add('Inserted record in to wsh_itm_items...' , 1 ) ;

1294: FND_GLOBAL.USER_ID
1295: );
1296:
1297: IF l_debug_level > 0 THEN
1298: oe_debug_pub.add('Inserted record in to wsh_itm_items...' , 1 ) ;
1299: END IF;
1300:
1301: END IF;
1302: