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.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on OE_TRANSACTION_TYPES_ALL

Line 70: FROM oe_transaction_types_all a, oe_transaction_types_tl b

66:
67: -- This cursor is used to get the warehouse for the Order and Line Transaction types
68: CURSOR l_oetranstypesall_csr(cp_trans_id NUMBER) IS
69: SELECT warehouse_id, default_outbound_line_type_id, name
70: FROM oe_transaction_types_all a, oe_transaction_types_tl b
71: WHERE a.transaction_type_id = b.transaction_type_id
72: AND a.transaction_type_id = cp_trans_id;
73:
74: -- check the Remarketing flow options from the setup

Line 359: -- This fetch will definitely find the record in oe_transaction_types_all

355:
356: -- get the warehouse and the Line Type for the Default Order Type
357: OPEN l_oetranstypesall_csr(l_default_order_type_id);
358: FETCH l_oetranstypesall_csr INTO l_order_warehouse_id, l_def_outbound_line_type_id, l_order_name;
359: -- This fetch will definitely find the record in oe_transaction_types_all
360: CLOSE l_oetranstypesall_csr;
361:
362:
363: IF l_order_warehouse_id IS NULL THEN

Line 390: -- This fetch will definitely find the record in oe_transaction_types_all

386:
387: -- get the warehouse for the Line type corresponding to the Default Order Type
388: OPEN l_oetranstypesall_csr(l_def_outbound_line_type_id);
389: FETCH l_oetranstypesall_csr INTO l_line_warehouse_id, l_def_outbound_line_type_id, l_line_name;
390: -- This fetch will definitely find the record in oe_transaction_types_all
391: CLOSE l_oetranstypesall_csr;
392:
393: IF l_line_warehouse_id IS NULL THEN
394: x_return_status := OKL_API.G_RET_STS_ERROR;