APPS.ENI_ITEMS_STAR_PKG dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 20: FROM mtl_default_category_sets

16: IS
17:
18: CURSOR get_po_catset IS
19: SELECT category_set_id
20: FROM mtl_default_category_sets
21: WHERE functional_area_id = 2;
22:
23: CURSOR c IS
24: SELECT category_set_id

Line 25: FROM mtl_default_category_sets

21: WHERE functional_area_id = 2;
22:
23: CURSOR c IS
24: SELECT category_set_id
25: FROM mtl_default_category_sets
26: WHERE functional_area_id = 1;
27:
28: CURSOR c_mult_item_assgn(l_inv_category_set NUMBER, l_vbh_category_set NUMBER, l_po_category_set NUMBER)
29: IS

Line 751: FROM mtl_default_category_sets

747: , x_msg_data OUT NOCOPY VARCHAR2 )
748: IS
749: CURSOR get_po_catset IS
750: SELECT category_set_id
751: FROM mtl_default_category_sets
752: WHERE functional_area_id = 2;
753:
754: CURSOR category_rec IS
755: SELECT category_set_id

Line 756: FROM mtl_default_category_sets

752: WHERE functional_area_id = 2;
753:
754: CURSOR category_rec IS
755: SELECT category_set_id
756: FROM mtl_default_category_sets
757: WHERE functional_area_id = 1;
758:
759: l_inv_category_set NUMBER;
760: l_vbh_category_set NUMBER;

Line 1137: FROM mtl_default_category_sets a, mtl_category_sets_b b

1133: begin
1134: -- Which category set does assignment belong in ?
1135:
1136: SELECT 'INV_CATEGORY' INTO which_category_set
1137: FROM mtl_default_category_sets a, mtl_category_sets_b b
1138: WHERE a.functional_area_id = 1
1139: AND a.category_set_id = b.category_set_id
1140: AND b.structure_id = p_structure_id;
1141:

Line 1264: FROM mtl_default_category_sets

1260: AND mic2.category_set_id (+) = l_PO_category_set_id;
1261:
1262: CURSOR get_po_catset IS
1263: SELECT category_set_id
1264: FROM mtl_default_category_sets
1265: WHERE functional_area_id = 2;
1266:
1267: BEGIN
1268:

Line 1278: FROM mtl_default_category_sets

1274: end if;
1275:
1276: SELECT category_set_id
1277: INTO l_INV_category_set_id
1278: FROM mtl_default_category_sets
1279: WHERE functional_area_id = 1;
1280:
1281: l_VBH_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
1282:

Line 1435: FROM mtl_default_category_sets

1431: IS
1432:
1433: CURSOR get_po_catset IS
1434: SELECT category_set_id
1435: FROM mtl_default_category_sets
1436: WHERE functional_area_id = 2;
1437:
1438: l_inv_category_set number;
1439: l_vbh_category_set number;

Line 1474: FROM mtl_default_category_sets

1470: FND_MSG_PUB.Initialize ;
1471: END IF;
1472:
1473: SELECT category_set_id INTO l_inv_category_set
1474: FROM mtl_default_category_sets
1475: WHERE functional_area_id = 1;
1476:
1477: -- Bug : 3671737 made changes to use Bind variables for local variables
1478: l_sql := 'MERGE INTO eni_oltp_item_star STAR

Line 1849: FROM mtl_default_category_sets

1845: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
1846:
1847: CURSOR get_po_catset IS
1848: SELECT category_set_id
1849: FROM mtl_default_category_sets
1850: WHERE functional_area_id = 2;
1851:
1852: l_user_id number;
1853: l_conc_request_id number;

Line 1902: FROM mtl_default_category_sets

1898: FND_MSG_PUB.Initialize ;
1899: END IF;
1900:
1901: SELECT category_set_id INTO l_inv_category_set_id
1902: FROM mtl_default_category_sets
1903: WHERE functional_area_id = 1;
1904:
1905:
1906: FOR sync_itmcatg IN icoi_csr(