APPS.INV_MINMAX_PVT dependencies on MFG_LOOKUPS

Line 2646: FROM mfg_lookups

2642: , 9);
2643: END IF;
2644: SELECT meaning
2645: INTO l_error_message
2646: FROM mfg_lookups
2647: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
2648: AND lookup_code = 7;
2649: RETURN(l_error_message);
2650: ELSIF (p_level = 1 AND p_item_rec.src_type = 3 AND p_item_rec.mbf = 2) THEN

Line 2658: FROM mfg_lookups

2654: , 9);
2655: END IF;
2656: SELECT meaning
2657: INTO l_error_message
2658: FROM mfg_lookups
2659: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
2660: AND lookup_code = 6;
2661: RETURN(l_error_message);
2662: ELSE

Line 3463: -- (Lookup Type 'MTL_REQUISITION_APPROVAL' defined in MFG_LOOKUPS)

3459: -- get_move_order_header_id.
3460: --
3461: -- the profile value set at the profile "INV: Minmax Reorder Approval"
3462: -- This profile can have 3 values:
3463: -- (Lookup Type 'MTL_REQUISITION_APPROVAL' defined in MFG_LOOKUPS)
3464: -- 1- Pre-approve d
3465: -- 2- Pre-approve move orders only
3466: -- 3- Approval Required
3467: -- Converting these codes to the ones defined in MFG_LOOKUPS under the

Line 3467: -- Converting these codes to the ones defined in MFG_LOOKUPS under the

3463: -- (Lookup Type 'MTL_REQUISITION_APPROVAL' defined in MFG_LOOKUPS)
3464: -- 1- Pre-approve d
3465: -- 2- Pre-approve move orders only
3466: -- 3- Approval Required
3467: -- Converting these codes to the ones defined in MFG_LOOKUPS under the
3468: -- lookup type'MTL_TXN_REQUEST_STATUS'.
3469: -- IF l_approval = 3 THEN
3470: -- l_approval := 1; -- Incomplete
3471: -- ELSE

Line 3782: FROM mfg_lookups

3778: WHEN requisition_exc THEN
3779: ROLLBACK TO sp_do_restock;
3780: SELECT meaning
3781: INTO x_ret_mesg
3782: FROM mfg_lookups
3783: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3784: AND lookup_code = 1;
3785:
3786: x_ret_stat := FND_API.G_RET_STS_ERROR;

Line 3792: FROM mfg_lookups

3788: WHEN move_ord_exc THEN
3789: ROLLBACK TO sp_do_restock;
3790: SELECT meaning
3791: INTO x_ret_mesg
3792: FROM mfg_lookups
3793: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
3794: AND lookup_code = 5;
3795:
3796: x_ret_stat := FND_API.G_RET_STS_ERROR;

Line 4099: FROM mfg_lookups

4095: END IF;
4096:
4097: SELECT meaning
4098: INTO x_ret_mesg
4099: FROM mfg_lookups
4100: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4101: AND lookup_code = 1;
4102:
4103: x_ret_stat := FND_API.G_RET_STS_ERROR;

Line 4389: FROM mfg_lookups

4385: END IF;
4386:
4387: SELECT meaning
4388: INTO x_ret_mesg
4389: FROM mfg_lookups
4390: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4391: AND lookup_code = 2;
4392:
4393: x_ret_stat := FND_API.G_RET_STS_ERROR;

Line 4510: FROM mfg_lookups

4506: END IF;
4507:
4508: SELECT meaning
4509: INTO x_ret_mesg
4510: FROM mfg_lookups
4511: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
4512: AND lookup_code = 2;
4513:
4514: x_ret_stat := FND_API.G_RET_STS_ERROR;