DBA Data[Home] [Help]

APPS.AMS_MTL_CATG_LOADER_PVT dependencies on MTL_CATEGORIES_VL

Line 29: -- from mtl_categories_vl

25: valid_ccid boolean ;
26:
27: /** USE DISABLE DATE
28: -- cursor c1 is select category_id, structure_id
29: -- from mtl_categories_vl
30: -- where ENABLED_FLAG = 'Y'
31: -- and nvl(START_DATE_ACTIVE,sysdate) <= sysdate
32: -- and nvl(END_DATE_ACTIVE,sysdate) >= sysdate ;
33: ***/

Line 37: from mtl_categories_vl

33: ***/
34:
35:
36: cursor c1 is select category_id, structure_id
37: from mtl_categories_vl
38: where nvl(DISABLE_DATE,sysdate) >= sysdate ;
39:
40: c1_rec c1%ROWTYPE;
41:

Line 353: from mtl_categories_vl

349:
350: CURSOR c_get_cat_name( cat_id IN NUMBER)
351: IS
352: SELECT description
353: from mtl_categories_vl
354: where category_id = cat_id ;
355:
356: l_cat_name_rec c_get_cat_name%ROWTYPE;
357: i number := 0;