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 1825: FROM mfg_lookups

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

Line 1892: FROM mfg_lookups

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