DBA Data[Home] [Help]

APPS.OKC_XPRT_QUOTE_INT_PVT dependencies on MTL_ITEM_CATEGORIES

Line 723: Mtl_Item_Categories mic,

719: SELECT
720: cats.category_concat_segs
721: BULK COLLECT INTO x_line_var_value_tbl.category
722: FROM
723: Mtl_Item_Categories mic,
724: Aso_Quote_Lines_all lines,
725: Mtl_Categories_V cats
726: WHERE
727: lines.inventory_item_id = mic.INVENTORY_ITEM_ID

Line 871: Mtl_Item_Categories mic,

867: CURSOR c_get_quote_item_category (p_quote_line_id NUMBER) IS
868: SELECT
869: cats.category_concat_segs item_category
870: FROM
871: Mtl_Item_Categories mic,
872: Aso_Quote_Lines_all lines,
873: Mtl_Categories_V cats
874: WHERE
875: lines.inventory_item_id = mic.INVENTORY_ITEM_ID