DBA Data[Home] [Help]

APPS.GML_ACCT_GENERATE dependencies on GMI_CATEGORY_SETS

Line 243: FROM gmi_category_sets gcs, gmi_item_categories gic

239: /* Bug 2312653 RVK */
240: Cursor category_ids(p_item_id ic_item_mst.item_id%TYPE)
241: IS
242: SELECT gic.item_id, gcs.opm_class, gic.category_id
243: FROM gmi_category_sets gcs, gmi_item_categories gic
244: WHERE gic.item_id = p_item_id
245: AND gic.category_set_id = gcs.category_set_id
246: AND gcs.category_set_id IS NOT NULL
247: AND gcs.opm_class in ('GL_BUSINESS_CLASS', 'GL_PRODUCT_LINE');