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.INV_REPLENISH_DETAIL_PUB dependencies on MTL_PARAMETERS

Line 229: FROM mtl_parameters

225: -- The parameter is for whether pick confirm is required or not,
226: -- so the auto-pick confirm flag is the opposite of this.
227: SELECT DECODE(NVL(mo_pick_confirm_required, 2), 1, 2, 2, 1, 1)
228: INTO l_auto_pick_confirm
229: FROM mtl_parameters
230: WHERE organization_id = l_trolin_tbl(1).organization_id;
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
233: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');

Line 1971: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters

1967: print_debug('OVPK: Move Order Type = ' || l_move_order_type);
1968: END IF;
1969:
1970: -- For a Replenishment (MO Type 2) / Requisition (MO Type 1)
1971: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters
1972:
1973: IF (l_move_order_type IN
1974: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
1975: ) THEN

Line 1978: FROM mtl_parameters

1974: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
1975: ) THEN
1976: SELECT OVPK_TRANSFER_ORDERS_ENABLED
1977: INTO l_temp
1978: FROM mtl_parameters
1979: WHERE organization_id = l_org_id;
1980:
1981: IF (NVL(l_temp, 'Y') = 'Y') THEN
1982: x_ovpk_allowed := 1; --Overpicking is allowed

Line 1990: print_debug('OVPK: In MTL_PARAMETERS OVPK_TRANSFER_ORDERS_ENABLED = ' || l_temp);

1986:
1987: x_max_qty_allowed := -1;
1988:
1989: IF (l_debug = 1) THEN
1990: print_debug('OVPK: In MTL_PARAMETERS OVPK_TRANSFER_ORDERS_ENABLED = ' || l_temp);
1991: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
1992: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
1993: print_debug('OVPK: Returning from get_overpick_qty');
1994: END IF;

Line 2000: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters

1996: RETURN;
1997: END IF;
1998:
1999: -- For a Manufacturing Component Pick(WIP) MO
2000: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters
2001: -- MO Type 5
2002: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
2003: SELECT wip_overpick_enabled
2004: INTO l_temp

Line 2005: FROM mtl_parameters

2001: -- MO Type 5
2002: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
2003: SELECT wip_overpick_enabled
2004: INTO l_temp
2005: FROM mtl_parameters
2006: WHERE organization_id = l_org_id;
2007:
2008: IF (NVL(l_temp, 'N') = 'Y') THEN
2009: x_ovpk_allowed := 1; --Overpicking is allowed

Line 2017: print_debug('OVPK: In MTL_PARAMETERS wip_overpick_enabled = ' || l_temp);

2013:
2014: x_max_qty_allowed := -1;
2015:
2016: IF (l_debug = 1) THEN
2017: print_debug('OVPK: In MTL_PARAMETERS wip_overpick_enabled = ' || l_temp);
2018: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
2019: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
2020: print_debug('OVPK: Returning from get_overpick_qty');
2021: END IF;

Line 2854: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters

2850: print_debug('OVPK: Move Order Type = ' || l_move_order_type);
2851: END IF;
2852:
2853: -- For a Replenishment (MO Type 2) / Requisition (MO Type 1)
2854: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters
2855:
2856: IF (l_move_order_type IN
2857: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
2858: ) THEN

Line 2861: FROM mtl_parameters

2857: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
2858: ) THEN
2859: SELECT OVPK_TRANSFER_ORDERS_ENABLED
2860: INTO l_temp
2861: FROM mtl_parameters
2862: WHERE organization_id = l_org_id;
2863:
2864: IF (NVL(l_temp, 'Y') = 'Y') THEN
2865: x_ovpk_allowed := 1; --Overpicking is allowed

Line 2873: print_debug('OVPK: In MTL_PARAMETERS OVPK_TRANSFER_ORDERS_ENABLED = ' || l_temp);

2869:
2870: x_max_qty_allowed := -1;
2871:
2872: IF (l_debug = 1) THEN
2873: print_debug('OVPK: In MTL_PARAMETERS OVPK_TRANSFER_ORDERS_ENABLED = ' || l_temp);
2874: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
2875: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
2876: print_debug('OVPK: Returning from get_overpick_qty');
2877: END IF;

Line 2883: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters

2879: RETURN;
2880: END IF;
2881:
2882: -- For a Manufacturing Component Pick(WIP) MO
2883: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters
2884: -- MO Type 5
2885: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
2886: SELECT wip_overpick_enabled
2887: INTO l_temp

Line 2888: FROM mtl_parameters

2884: -- MO Type 5
2885: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
2886: SELECT wip_overpick_enabled
2887: INTO l_temp
2888: FROM mtl_parameters
2889: WHERE organization_id = l_org_id;
2890:
2891: IF (NVL(l_temp, 'N') = 'Y') THEN
2892: x_ovpk_allowed := 1; --Overpicking is allowed

Line 2900: print_debug('OVPK: In MTL_PARAMETERS wip_overpick_enabled = ' || l_temp);

2896:
2897: x_max_qty_allowed := -1;
2898:
2899: IF (l_debug = 1) THEN
2900: print_debug('OVPK: In MTL_PARAMETERS wip_overpick_enabled = ' || l_temp);
2901: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
2902: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
2903: print_debug('OVPK: Returning from get_overpick_qty');
2904: END IF;