DBA Data[Home] [Help]

APPS.ASO_CONTRACT_TERMS_INT dependencies on MTL_ITEM_CATEGORIES

Line 486: FROM Mtl_Item_Categories mic, Aso_Quote_Lines_All lines, Mtl_Categories_V cats

482: END IF;
483:
484: SELECT DISTINCT Category_Concat_Segs
485: BULK COLLECT INTO x_line_var_value_tbl.category
486: FROM Mtl_Item_Categories mic, Aso_Quote_Lines_All lines, Mtl_Categories_V cats
487: WHERE lines.inventory_item_id = mic.INVENTORY_ITEM_ID
488: AND mic.category_id = cats.category_id
489: AND mic.organization_id = lines.organization_id
490: AND mic. category_set_id =