DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_TRANSACTION_REASONS

Line 4926: FROM mtl_transaction_reasons

4922: IF (p_qty_reason_id > 0) THEN
4923: BEGIN
4924: SELECT 1
4925: INTO l_wf
4926: FROM mtl_transaction_reasons
4927: WHERE reason_id = p_qty_reason_id
4928: AND workflow_name IS NOT NULL
4929: AND workflow_name <> ' '
4930: AND workflow_process IS NOT NULL

Line 4998: FROM mtl_transaction_reasons

4994: SELECT 1,
4995: workflow_process
4996: INTO l_wf,
4997: l_wf_process
4998: FROM mtl_transaction_reasons
4999: WHERE reason_id = p_loc_reason_id
5000: AND workflow_name IS NOT NULL
5001: AND workflow_name <> ' '
5002: AND workflow_process IS NOT NULL

Line 5379: FROM mtl_transaction_reasons

5375: IF (p_qty_reason_id > 0) THEN
5376: BEGIN
5377: SELECT 1
5378: INTO l_wf
5379: FROM mtl_transaction_reasons
5380: WHERE reason_id = p_qty_reason_id
5381: AND workflow_name IS NOT NULL
5382: AND workflow_name <> ' '
5383: AND workflow_process IS NOT NULL

Line 5452: FROM mtl_transaction_reasons

5448: SELECT 1,
5449: workflow_process
5450: INTO l_wf,
5451: l_wf_process
5452: FROM mtl_transaction_reasons
5453: WHERE reason_id = p_loc_reason_id
5454: AND workflow_name IS NOT NULL
5455: AND workflow_name <> ' '
5456: AND workflow_process IS NOT NULL