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 2398: IF OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y'

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

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

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

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

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

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

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

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

2402: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2403: AND p_action_code = OE_GLOBALS.G_GET_SHIP_METHOD THEN
2404: l_action := 'C';
2405: ELSIF (OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'F'
2406: OR OE_SYS_PARAMETERS.Value('FTE_INTEGRATION') = 'Y')
2407: AND p_action_code = OE_GLOBALS.G_GET_FREIGHT_RATES THEN
2408: l_action := 'R';
2409: END IF;
2410:

Line 3234: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')

3230: AND l.inventory_item_id = m.inventory_item_id
3231: AND nvl(m.returnable_flag,'Y') = 'Y'
3232: AND nvl(l.cancelled_flag,'N') = 'N'
3233: AND m.organization_id =
3234: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')
3235: ORDER BY LINE_NUMBER , SHIPMENT_NUMBER ,NVL(OPTION_NUMBER, -1),
3236: NVL(COMPONENT_NUMBER,-1),NVL(SERVICE_NUMBER,-1);
3237:
3238: /* Added the order by to fix bug 2226940 */

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

3532: primary_uom_code
3533: FROM mtl_system_items msi
3534: WHERE msi.inventory_item_id = l_inventory_item_id
3535: AND msi.organization_id =
3536: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3537:
3538: -- Now Absolute value of transaction_quantity is selected to fix 1610964.
3539: -- Modified query to take care of over-shipped order lines(Bug # 1643433).
3540: -- Removed the view mtl_transaction_lot_val_v in the below cursor and used the tables involved in the view for bug 5395763

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

4277: -- AND l.item_type_code in ('INCLUDED','CLASS','OPTION')
4278: -- AND exists (select null from mtl_system_items mtl where
4279: -- mtl.inventory_item_id = l.inventory_item_id and
4280: -- mtl.serviceable_product_flag = 'Y' and
4281: -- mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4282: --lchen added check for organizations to fix bug 2039304
4283:
4284: CURSOR srv_number IS
4285: SELECT max(l.service_number) service_number

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

4390: AND l.item_type_code = 'INCLUDED'
4391: AND exists (select null from mtl_system_items mtl where
4392: mtl.inventory_item_id = l.inventory_item_id and
4393: mtl.serviceable_product_flag = 'Y' and
4394: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4395: ELSE
4396:
4397: OPEN srv_children FOR
4398: SELECT l.header_id,

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

4415: AND l.item_type_code in ('INCLUDED','CLASS','OPTION', 'KIT') -- For bug 2447402
4416: AND exists (select null from mtl_system_items mtl where
4417: mtl.inventory_item_id = l.inventory_item_id and
4418: mtl.serviceable_product_flag = 'Y' and
4419: mtl.organization_id=OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID') );
4420: END IF; /* source_type_doc_id = 2 */
4421: -- End 2372098
4422:
4423: -- For bug 2372098