DBA Data[Home] [Help]

APPS.ASO_CONTRACT_TERMS_INT dependencies on MTL_SYSTEM_ITEMS_B

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;