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 260: FROM mtl_parameters

256: -- The parameter is for whether pick confirm is required or not,
257: -- so the auto-pick confirm flag is the opposite of this.
258: SELECT DECODE(NVL(mo_pick_confirm_required, 2), 1, 2, 2, 1, 1)
259: INTO l_auto_pick_confirm
260: FROM mtl_parameters
261: WHERE organization_id = l_trolin_tbl(1).organization_id;
262: EXCEPTION
263: WHEN NO_DATA_FOUND THEN
264: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');

Line 2198: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters

2194: print_debug('OVPK: Move Order Type = ' || l_move_order_type);
2195: END IF;
2196:
2197: -- For a Replenishment (MO Type 2) / Requisition (MO Type 1)
2198: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters
2199:
2200: IF (l_move_order_type IN
2201: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
2202: ) THEN

Line 2205: FROM mtl_parameters

2201: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
2202: ) THEN
2203: SELECT OVPK_TRANSFER_ORDERS_ENABLED
2204: INTO l_temp
2205: FROM mtl_parameters
2206: WHERE organization_id = l_org_id;
2207:
2208: IF (NVL(l_temp, 'Y') = 'Y') THEN
2209: x_ovpk_allowed := 1; --Overpicking is allowed

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

2213:
2214: x_max_qty_allowed := -1;
2215:
2216: IF (l_debug = 1) THEN
2217: print_debug('OVPK: In MTL_PARAMETERS OVPK_TRANSFER_ORDERS_ENABLED = ' || l_temp);
2218: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
2219: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
2220: print_debug('OVPK: Returning from get_overpick_qty');
2221: END IF;

Line 2227: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters

2223: RETURN;
2224: END IF;
2225:
2226: -- For a Manufacturing Component Pick(WIP) MO
2227: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters
2228: -- MO Type 5
2229: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
2230: SELECT wip_overpick_enabled
2231: INTO l_temp

Line 2232: FROM mtl_parameters

2228: -- MO Type 5
2229: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
2230: SELECT wip_overpick_enabled
2231: INTO l_temp
2232: FROM mtl_parameters
2233: WHERE organization_id = l_org_id;
2234:
2235: IF (NVL(l_temp, 'N') = 'Y') THEN
2236: x_ovpk_allowed := 1; --Overpicking is allowed

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

2240:
2241: x_max_qty_allowed := -1;
2242:
2243: IF (l_debug = 1) THEN
2244: print_debug('OVPK: In MTL_PARAMETERS wip_overpick_enabled = ' || l_temp);
2245: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
2246: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
2247: print_debug('OVPK: Returning from get_overpick_qty');
2248: END IF;

Line 3208: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters

3204: print_debug('OVPK: Move Order Type = ' || l_move_order_type);
3205: END IF;
3206:
3207: -- For a Replenishment (MO Type 2) / Requisition (MO Type 1)
3208: -- lookup the flag OVPK_TRANSFER_ORDERS_ENABLED in mtl_parameters
3209:
3210: IF (l_move_order_type IN
3211: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
3212: ) THEN

Line 3215: FROM mtl_parameters

3211: (inv_globals.g_move_order_replenishment, inv_globals.g_move_order_requisition)
3212: ) THEN
3213: SELECT OVPK_TRANSFER_ORDERS_ENABLED
3214: INTO l_temp
3215: FROM mtl_parameters
3216: WHERE organization_id = l_org_id;
3217:
3218: IF (NVL(l_temp, 'Y') = 'Y') THEN
3219: x_ovpk_allowed := 1; --Overpicking is allowed

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

3223:
3224: x_max_qty_allowed := -1;
3225:
3226: IF (l_debug = 1) THEN
3227: print_debug('OVPK: In MTL_PARAMETERS OVPK_TRANSFER_ORDERS_ENABLED = ' || l_temp);
3228: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
3229: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
3230: print_debug('OVPK: Returning from get_overpick_qty');
3231: END IF;

Line 3237: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters

3233: RETURN;
3234: END IF;
3235:
3236: -- For a Manufacturing Component Pick(WIP) MO
3237: -- lookup the flag WIP_OVERPICK_ENABLED in mtl_parameters
3238: -- MO Type 5
3239: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
3240: SELECT wip_overpick_enabled
3241: INTO l_temp

Line 3242: FROM mtl_parameters

3238: -- MO Type 5
3239: IF (l_move_order_type = inv_globals.g_move_order_mfg_pick) THEN
3240: SELECT wip_overpick_enabled
3241: INTO l_temp
3242: FROM mtl_parameters
3243: WHERE organization_id = l_org_id;
3244:
3245: IF (NVL(l_temp, 'N') = 'Y') THEN
3246: x_ovpk_allowed := 1; --Overpicking is allowed

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

3250:
3251: x_max_qty_allowed := -1;
3252:
3253: IF (l_debug = 1) THEN
3254: print_debug('OVPK: In MTL_PARAMETERS wip_overpick_enabled = ' || l_temp);
3255: print_debug('OVPK: x_ovpk_allowed = ' || x_ovpk_allowed);
3256: print_debug('OVPK: x_max_qty_allowed = ' || x_max_qty_allowed);
3257: print_debug('OVPK: Returning from get_overpick_qty');
3258: END IF;