DBA Data[Home] [Help]

APPS.ASO_FIND_HIERARCHY_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 126: MTL_SYSTEM_ITEMS_TL msit

122: (qte_lines.line_list_price * qte_lines.quantity) amount ,
123: (qte_lines.line_adjusted_amount * qte_lines.quantity) line_adjusted_amount
124: From ASO_QUOTE_LINES_ALL qte_lines ,
125: MTL_SYSTEM_ITEMS_B_KFV items,
126: MTL_SYSTEM_ITEMS_TL msit
127: Where qte_lines.quote_header_id = p_quote_header_id
128: AND qte_lines.inventory_item_id = items.inventory_item_id
129: AND qte_lines.organization_id = items.organization_id
130: AND items.inventory_item_id = msit.inventory_item_id