APPS.WMS_TASK_DISPATCH_GEN dependencies on MTL_PARAMETERS

Line 897: FROM wms_skip_task_exceptions wste, mtl_parameters mp

893: DELETE FROM wms_skip_task_exceptions
894: WHERE task_id = task_rec.task_id
895: AND task_id IN(
896: SELECT wste.task_id
897: FROM wms_skip_task_exceptions wste, mtl_parameters mp
898: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
899: AND wste.task_id = task_rec.task_id
900: AND wste.organization_id = mp.organization_id);
901:

Line 1452: FROM wms_skip_task_exceptions wste, mtl_parameters mp

1448: DELETE FROM wms_skip_task_exceptions
1449: WHERE task_id = task_rec.task_id
1450: AND task_id IN(
1451: SELECT wste.task_id
1452: FROM wms_skip_task_exceptions wste, mtl_parameters mp
1453: WHERE ABS((SYSDATE - wste.creation_date) * 24 * 60) > mp.skip_task_waiting_minutes
1454: AND wste.task_id = task_rec.task_id
1455: AND wste.organization_id = mp.organization_id);
1456:

Line 13936: FROM mtl_parameters

13932: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
13933: BEGIN
13934: SELECT negative_inv_receipt_code
13935: INTO l_negative_rcpt_code
13936: FROM mtl_parameters
13937: WHERE organization_id = p_organization_id;
13938:
13939: IF (l_negative_rcpt_code = 1) THEN
13940: -- Negative inventory balances allowed