DBA Data[Home] [Help]

APPS.CSP_PLANNER_NOTIFICATIONS dependencies on MFG_LOOKUPS

Line 284: FROM MFG_LOOKUPS

280: if p_restock = 1 and p_dd_loc_id is null then
281: begin
282: Select MEANING
283: into error_message
284: FROM MFG_LOOKUPS
285: WHERE LOOKUP_TYPE='INV_MMX_RPT_MSGS'
286: and LOOKUP_CODE = 4;
287: exception
288: when others then

Line 1828: FROM mfg_lookups

1824: --print_debug(sqlcode || ', ' || sqlerrm, 're_po', 1);
1825:
1826: SELECT meaning
1827: INTO x_ret_mesg
1828: FROM mfg_lookups
1829: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
1830: AND lookup_code = 1;
1831:
1832: x_ret_stat := FND_API.G_RET_STS_ERROR;

Line 1895: FROM mfg_lookups

1891: --print_debug(sqlcode || ', ' || sqlerrm, 're_wip', 1);
1892:
1893: SELECT meaning
1894: INTO x_ret_mesg
1895: FROM mfg_lookups
1896: WHERE lookup_type = 'INV_MMX_RPT_MSGS'
1897: AND lookup_code = 2;
1898:
1899: x_ret_stat := FND_API.G_RET_STS_ERROR;