DBA Data[Home] [Help]

APPS.ASO_CONTRACT_TERMS_INT dependencies on ASO_QUOTE_LINES_ALL

Line 467: FROM Mtl_System_Items_b items, Aso_Quote_Lines_All lines

463: END IF;
464:
465: SELECT DISTINCT Segment1
466: BULK COLLECT INTO x_line_var_value_tbl.item
467: FROM Mtl_System_Items_b items, Aso_Quote_Lines_All lines
468: WHERE lines.inventory_item_id = items.INVENTORY_ITEM_ID
469: AND lines.organization_id = items.organization_id
470: AND lines.LINE_CATEGORY_CODE = 'ORDER'
471: AND lines.quote_header_id = p_doc_id;

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 =