APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_TRANSACTION_REASONS

Line 752: FROM mtl_transaction_reasons mtr

748: -- Do not update transaction_quantity to 0 when Pick Partial
749: BEGIN
750: SELECT 'N'
751: INTO l_do_update_mmtt
752: FROM mtl_transaction_reasons mtr
753: , wms_exceptions we
754: WHERE we.reason_id = mtr.reason_id
755: AND we.task_id = l_mmtt_id
756: AND mtr.workflow_process = 'WMS_CYC_COUNT'

Line 1851: FROM mtl_transaction_reasons

1847: THEN
1848: BEGIN
1849: SELECT 1
1850: INTO l_wf
1851: FROM mtl_transaction_reasons
1852: WHERE reason_id = p_qty_rsn_id
1853: AND workflow_name IS NOT NULL
1854: AND workflow_name <> ' '
1855: AND workflow_process IS NOT NULL

Line 2328: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;

2324: l_subinventory_code wms_exceptions.subinventory_code%TYPE;
2325: l_locator_id NUMBER;
2326: l_lpn_id NUMBER;
2327: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2328: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;
2329: l_workflow_process mtl_transaction_reasons.workflow_process%TYPE;
2330: l_user_id NUMBER := fnd_global.user_id;
2331:
2332: BEGIN

Line 2329: l_workflow_process mtl_transaction_reasons.workflow_process%TYPE;

2325: l_locator_id NUMBER;
2326: l_lpn_id NUMBER;
2327: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2328: l_workflow_name mtl_transaction_reasons.workflow_name%TYPE;
2329: l_workflow_process mtl_transaction_reasons.workflow_process%TYPE;
2330: l_user_id NUMBER := fnd_global.user_id;
2331:
2332: BEGIN
2333: x_return_status := 'S';