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.OE_BLANKET_UTIL dependencies on OE_SYS_PARAMETERS

Line 2168: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

2164:
2165: --code taken from OE_validate_line.validate_item_fields
2166: /* added for 2219230 */
2167: l_org_flag NUMBER := 2;
2168: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2169:
2170: CURSOR xref IS
2171: SELECT DECODE(items.org_independent_flag, 'Y', 1,
2172: DECODE(items.organization_id, item_val_org, 1, 2))

Line 2207: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')

2203: SELECT 'valid'
2204: INTO l_dummy
2205: FROM mtl_system_items_b
2206: WHERE inventory_item_id = p_inventory_item_id
2207: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
2208: AND customer_order_enabled_flag = 'Y';
2209:
2210: ELSIF p_item_identifier_type = 'CUST' THEN
2211: if l_debug_level > 0 then

Line 2223: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')

2219: WHERE citems.customer_item_id = cxref.customer_item_id
2220: AND cxref.inventory_item_id = sitems.inventory_item_id
2221: AND sitems.inventory_item_id = p_inventory_item_id
2222: AND sitems.organization_id =
2223: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
2224: AND citems.customer_item_id = p_ordered_item_id
2225: AND citems.customer_id = p_sold_to_org_id
2226: AND citems.inactive_flag = 'N'
2227: AND cxref.inactive_flag = 'N';

Line 2284: l_item_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

2280: )
2281: RETURN BOOLEAN
2282: IS
2283: l_rule_type VARCHAR2(10);
2284: l_item_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2285: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2286: l_service_item_flag VARCHAR2(1);
2287: l_bom_item_type NUMBER;
2288: l_dummy VARCHAR2(25);

Line 6768: WHERE SET_OF_BOOKS_ID = OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');

6764: BEGIN
6765: SELECT CURRENCY_CODE
6766: INTO p_x_header_rec.transactional_curr_code
6767: FROM OE_GL_SETS_OF_BOOKS_V
6768: WHERE SET_OF_BOOKS_ID = OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');
6769: EXCEPTION
6770: WHEN OTHERS THEN
6771: NULL;
6772: END;

Line 7184: x_Set_Of_Books_Id := OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');

7180:
7181: --x_header_rec := p_header_rec;
7182: x_return_status := FND_API.G_RET_STS_SUCCESS;
7183:
7184: x_Set_Of_Books_Id := OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');
7185:
7186: IF p_x_header_rec.order_type_id IS NOT NULL THEN
7187: x_doc_category_code := p_x_header_rec.order_type_id;
7188:

Line 9453: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))

9449: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(
9450: Z_Customer_Item_Id => p_x_line_rec.ordered_item_id
9451: , Z_Customer_Id => p_x_line_rec.sold_to_org_id
9452: , Z_Address_Id => l_address_id
9453: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))
9454: , Z_Inventory_Item_Id => p_x_line_rec.inventory_item_id
9455: , Attribute_Name => 'INVENTORY_ITEM_ID'
9456: , Error_Code => l_error_code
9457: , Error_Flag => l_error_flag