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 363: -- This fetch will definitely find the record in oe_transaction_types_all

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

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

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