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 760: FROM mtl_default_category_sets

756: , x_msg_data OUT NOCOPY VARCHAR2 )
757: IS
758: CURSOR get_po_catset IS
759: SELECT category_set_id
760: FROM mtl_default_category_sets
761: WHERE functional_area_id = 2;
762:
763: CURSOR category_rec IS
764: SELECT category_set_id

Line 765: FROM mtl_default_category_sets

761: WHERE functional_area_id = 2;
762:
763: CURSOR category_rec IS
764: SELECT category_set_id
765: FROM mtl_default_category_sets
766: WHERE functional_area_id = 1;
767:
768: l_inv_category_set NUMBER;
769: l_vbh_category_set NUMBER;

Line 1317: FROM mtl_default_category_sets a, mtl_category_sets_b b

1313: begin
1314: -- Which category set does assignment belong in ?
1315:
1316: SELECT 'INV_CATEGORY' INTO which_category_set
1317: FROM mtl_default_category_sets a, mtl_category_sets_b b
1318: WHERE a.functional_area_id = 1
1319: AND a.category_set_id = b.category_set_id
1320: AND b.structure_id = p_structure_id;
1321:

Line 1444: FROM mtl_default_category_sets

1440: AND mic2.category_set_id (+) = l_PO_category_set_id;
1441:
1442: CURSOR get_po_catset IS
1443: SELECT category_set_id
1444: FROM mtl_default_category_sets
1445: WHERE functional_area_id = 2;
1446:
1447: BEGIN
1448:

Line 1458: FROM mtl_default_category_sets

1454: end if;
1455:
1456: SELECT category_set_id
1457: INTO l_INV_category_set_id
1458: FROM mtl_default_category_sets
1459: WHERE functional_area_id = 1;
1460:
1461: l_VBH_category_set_id := ENI_DENORM_HRCHY.get_category_set_id;
1462:

Line 1615: FROM mtl_default_category_sets

1611: IS
1612:
1613: CURSOR get_po_catset IS
1614: SELECT category_set_id
1615: FROM mtl_default_category_sets
1616: WHERE functional_area_id = 2;
1617:
1618: l_inv_category_set number;
1619: l_vbh_category_set number;

Line 1654: FROM mtl_default_category_sets

1650: FND_MSG_PUB.Initialize ;
1651: END IF;
1652:
1653: SELECT category_set_id INTO l_inv_category_set
1654: FROM mtl_default_category_sets
1655: WHERE functional_area_id = 1;
1656:
1657: -- Bug : 3671737 made changes to use Bind variables for local variables
1658: -- Bug 10404086 : Added below hint

Line 2033: FROM mtl_default_category_sets

2029: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
2030:
2031: CURSOR get_po_catset IS
2032: SELECT category_set_id
2033: FROM mtl_default_category_sets
2034: WHERE functional_area_id = 2;
2035:
2036: l_user_id number;
2037: l_conc_request_id number;

Line 2086: FROM mtl_default_category_sets

2082: FND_MSG_PUB.Initialize ;
2083: END IF;
2084:
2085: SELECT category_set_id INTO l_inv_category_set_id
2086: FROM mtl_default_category_sets
2087: WHERE functional_area_id = 1;
2088:
2089:
2090: FOR sync_itmcatg IN icoi_csr(