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_DELAYED_REQUESTS_UTIL dependencies on OE_SYS_PARAMETERS

Line 2394: IF OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y'

2390: END;
2391:
2392: END IF;
2393:
2394: IF OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y'
2395: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES THEN
2396: l_action := 'B';
2397: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'S'
2398: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')

Line 2397: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'S'

2393:
2394: IF OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y'
2395: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES THEN
2396: l_action := 'B';
2397: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'S'
2398: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2399: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD THEN
2400: l_action := 'C';
2401: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'F'

Line 2398: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')

2394: IF OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y'
2395: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD_AND_RATES THEN
2396: l_action := 'B';
2397: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'S'
2398: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2399: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD THEN
2400: l_action := 'C';
2401: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'F'
2402: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')

Line 2401: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'F'

2397: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'S'
2398: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2399: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD THEN
2400: l_action := 'C';
2401: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'F'
2402: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2403: AND p_action_code = OE_GLOBALS.G_GET_FREIGHT_RATES THEN
2404: l_action := 'R';
2405: END IF;

Line 2402: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')

2398: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2399: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD THEN
2400: l_action := 'C';
2401: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'F'
2402: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2403: AND p_action_code = OE_GLOBALS.G_GET_FREIGHT_RATES THEN
2404: l_action := 'R';
2405: END IF;
2406:

Line 3013: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')

3009: AND l.inventory_item_id = m.inventory_item_id
3010: AND nvl(m.returnable_flag,'Y') = 'Y'
3011: AND nvl(l.cancelled_flag,'N') = 'N'
3012: AND m.organization_id =
3013: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
3014: ORDER BY LINE_NUMBER , SHIPMENT_NUMBER ,NVL(OPTION_NUMBER, -1),
3015: NVL(COMPONENT_NUMBER,-1),NVL(SERVICE_NUMBER,-1);
3016:
3017: /* Added the order by to fix bug 2226940 */

Line 3293: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');

3289: primary_uom_code
3290: FROM mtl_system_items msi
3291: WHERE msi.inventory_item_id = l_inventory_item_id
3292: AND msi.organization_id =
3293: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3294:
3295: -- Now Absolute value of transaction_quantity is selected to fix 1610964.
3296: -- Modified query to take care of over-shipped order lines(Bug # 1643433).
3297: -- Removed the view mtl_transaction_lot_val_v in the below cursor and used the tables involved in the view for bug 5395763

Line 4000: -- mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );

3996: -- AND l.item_type_code in ('INCLUDED','CLASS','OPTION')
3997: -- AND exists (select null from mtl_system_items mtl where
3998: -- mtl.inventory_item_id = l.inventory_item_id and
3999: -- mtl.serviceable_product_flag = 'Y' and
4000: -- mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4001: --lchen added check for organizations to fix bug 2039304
4002:
4003: CURSOR srv_number IS
4004: SELECT max(l.service_number) service_number

Line 4075: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );

4071: AND l.item_type_code = 'INCLUDED'
4072: AND exists (select null from mtl_system_items mtl where
4073: mtl.inventory_item_id = l.inventory_item_id and
4074: mtl.serviceable_product_flag = 'Y' and
4075: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4076: ELSE
4077:
4078: OPEN srv_children FOR
4079: SELECT l.header_id,

Line 4100: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );

4096: AND l.item_type_code in ('INCLUDED','CLASS','OPTION', 'KIT') -- For bug 2447402
4097: AND exists (select null from mtl_system_items mtl where
4098: mtl.inventory_item_id = l.inventory_item_id and
4099: mtl.serviceable_product_flag = 'Y' and
4100: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4101: END IF; /* source_type_doc_id = 2 */
4102: -- End 2372098
4103:
4104: -- For bug 2372098

Line 5220: -- l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id);

5216: --l_header_Rec.org_id := l_org_id ;
5217: --l_header_Rec.conversion_rate := l_conversion_rate ;
5218:
5219:
5220: -- l_inventory_org_id := oe_sys_parameters.value('MASTER_ORGANIZATION_ID',l_org_id);
5221:
5222: l_request_ind := p_entity_id_tbl(l_index).request_ind;
5223: IF l_debug_level > 0 THEN
5224: oe_debug_pub.add( 'value count '|| OE_Delayed_Requests_PVT.G_Delayed_Requests.count);