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 2026: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));

2022:
2023: --code taken from OE_validate_line.validate_item_fields
2024: /* added for 2219230 */
2025: l_org_flag NUMBER := 2;
2026: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2027:
2028: CURSOR xref IS
2029: SELECT DECODE(items.org_independent_flag, 'Y', 1,
2030: DECODE(items.organization_id, item_val_org, 1, 2))

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

2061: SELECT 'valid'
2062: INTO l_dummy
2063: FROM mtl_system_items_b
2064: WHERE inventory_item_id = p_inventory_item_id
2065: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
2066: AND customer_order_enabled_flag = 'Y';
2067:
2068: ELSIF p_item_identifier_type = 'CUST' THEN
2069: if l_debug_level > 0 then

Line 2081: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')

2077: WHERE citems.customer_item_id = cxref.customer_item_id
2078: AND cxref.inventory_item_id = sitems.inventory_item_id
2079: AND sitems.inventory_item_id = p_inventory_item_id
2080: AND sitems.organization_id =
2081: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
2082: AND citems.customer_item_id = p_ordered_item_id
2083: AND citems.customer_id = p_sold_to_org_id
2084: AND citems.inactive_flag = 'N'
2085: AND cxref.inactive_flag = 'N';

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

2138: )
2139: RETURN BOOLEAN
2140: IS
2141: l_rule_type VARCHAR2(10);
2142: l_item_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2143: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2144: l_service_item_flag VARCHAR2(1);
2145: l_bom_item_type NUMBER;
2146: l_dummy VARCHAR2(25);

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

6570: BEGIN
6571: SELECT CURRENCY_CODE
6572: INTO p_x_header_rec.transactional_curr_code
6573: FROM OE_GL_SETS_OF_BOOKS_V
6574: WHERE SET_OF_BOOKS_ID = OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');
6575: EXCEPTION
6576: WHEN OTHERS THEN
6577: NULL;
6578: END;

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

6986:
6987: --x_header_rec := p_header_rec;
6988: x_return_status := FND_API.G_RET_STS_SUCCESS;
6989:
6990: x_Set_Of_Books_Id := OE_Sys_Parameters.VALUE('SET_OF_BOOKS_ID');
6991:
6992: IF p_x_header_rec.order_type_id IS NOT NULL THEN
6993: x_doc_category_code := p_x_header_rec.order_type_id;
6994:

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

9252: INV_CUSTOMER_ITEM_GRP.CI_Attribute_Value(
9253: Z_Customer_Item_Id => p_x_line_rec.ordered_item_id
9254: , Z_Customer_Id => p_x_line_rec.sold_to_org_id
9255: , Z_Address_Id => l_address_id
9256: , Z_Organization_Id => nvl(p_x_line_rec.ship_from_org_id, OE_Sys_Parameters.value('MASTER_ORGANIZATION_ID'))
9257: , Z_Inventory_Item_Id => p_x_line_rec.inventory_item_id
9258: , Attribute_Name => 'INVENTORY_ITEM_ID'
9259: , Error_Code => l_error_code
9260: , Error_Flag => l_error_flag