DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_TRANSACTION_REASONS

Line 5152: FROM mtl_transaction_reasons

5148: IF (p_qty_reason_id > 0) THEN
5149: BEGIN
5150: SELECT 1
5151: INTO l_wf
5152: FROM mtl_transaction_reasons
5153: WHERE reason_id = p_qty_reason_id
5154: AND workflow_name IS NOT NULL
5155: AND workflow_name <> ' '
5156: AND workflow_process IS NOT NULL

Line 5224: FROM mtl_transaction_reasons

5220: SELECT 1,
5221: workflow_process
5222: INTO l_wf,
5223: l_wf_process
5224: FROM mtl_transaction_reasons
5225: WHERE reason_id = p_loc_reason_id
5226: AND workflow_name IS NOT NULL
5227: AND workflow_name <> ' '
5228: AND workflow_process IS NOT NULL

Line 5625: FROM mtl_transaction_reasons

5621: IF (p_qty_reason_id > 0) THEN
5622: BEGIN
5623: SELECT 1
5624: INTO l_wf
5625: FROM mtl_transaction_reasons
5626: WHERE reason_id = p_qty_reason_id
5627: AND workflow_name IS NOT NULL
5628: AND workflow_name <> ' '
5629: AND workflow_process IS NOT NULL

Line 5698: FROM mtl_transaction_reasons

5694: SELECT 1,
5695: workflow_process
5696: INTO l_wf,
5697: l_wf_process
5698: FROM mtl_transaction_reasons
5699: WHERE reason_id = p_loc_reason_id
5700: AND workflow_name IS NOT NULL
5701: AND workflow_name <> ' '
5702: AND workflow_process IS NOT NULL