DBA Data[Home] [Help]

APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on MTL_ITEM_CATEGORIES

Line 585: and exists(select null from mtl_item_categories c

581: from jtf_rs_products_v a
582: where UPPER(PRODUCT_NAME) like l_display_value
583: and PRODUCT_ORG_ID = l_org_id
584: and nvl(a.enabled_flag, 'Y') <> 'N'
585: and exists(select null from mtl_item_categories c
586: where a.product_id = c.inventory_item_id
587: and c.organization_id = l_org_id
588: and c.category_id = l_aux_value1);
589:

Line 607: and exists(select null from mtl_item_categories c

603: from jtf_rs_products_v a
604: where UPPER(a.PRODUCT_NAME) like l_display_value
605: and a.PRODUCT_ORG_ID = l_org_id
606: and nvl(a.enabled_flag, 'Y') <> 'N'
607: and exists(select null from mtl_item_categories c
608: where a.product_id = c.inventory_item_id
609: and c.organization_id = l_org_id
610: and c.category_id = l_aux_value1)
611: order by a.PRODUCT_NAME;