DBA Data[Home] [Help]

APPS.INV_ITEM_CATEGORY_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 206: FROM MTL_DEFAULT_CATEGORY_SETS

202: --If item is an NIR item and it is not approved
203:
204: IF l_approval_status IS NOT NULL AND l_approval_status <> 'A' THEN
205: SELECT COUNT(*) INTO l_default_cats
206: FROM MTL_DEFAULT_CATEGORY_SETS
207: WHERE CATEGORY_SET_ID = p_category_set_id;
208: IF l_default_cats > 0 THEN
209: INV_ITEM_MSG.Add_Message
210: (p_Msg_Name => 'INV_IOI_NIR_NOT_COMPLETE'

Line 580: l_default_catalog_id MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID%TYPE;

576: FF10 VARCHAR2(1);
577: FF11 VARCHAR2(1);
578: FF12 VARCHAR2(1); --Bug:6485437
579: FF21 VARCHAR2(1);
580: l_default_catalog_id MTL_DEFAULT_CATEGORY_SETS.CATEGORY_SET_ID%TYPE;
581: gdsn_outbound_enabled_flag MTL_SYSTEM_ITEMS_B.GDSN_OUTBOUND_ENABLED_FLAG%TYPE;
582:
583: inv_item_flagg VARCHAR2(1);
584: purch_item_flagg VARCHAR2(1);

Line 617: FROM mtl_default_category_sets

613: --Bug:6485437
614: CURSOR default_catalog_csr(cp_functional_area NUMBER)
615: IS
616: SELECT category_set_id
617: FROM mtl_default_category_sets
618: WHERE functional_area_id = cp_functional_area;
619:
620: CURSOR fetch_gdsn_flag(cp_inventory_item_id NUMBER,
621: cp_organization_id NUMBER)