APPS.ASO_FIND_HIERARCHY_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 104: From ASO_QUOTE_LINES_ALL qte_lines ,

100: qte_lines.uom_code uom_code ,
101: qte_lines.quantity quantity ,
102: (qte_lines.line_list_price * qte_lines.quantity) amount ,
103: (qte_lines.line_adjusted_amount * qte_lines.quantity) line_adjusted_amount
104: From ASO_QUOTE_LINES_ALL qte_lines ,
105: ASO_I_ITEMS_V items
106: Where qte_lines.quote_header_id = p_quote_header_id
107: AND qte_lines.inventory_item_id = items.inventory_item_id
108: AND qte_lines.organization_id = items.organization_id

Line 124: From ASO_QUOTE_LINES_ALL qte_lines ,

120: qte_lines.uom_code uom_code ,
121: qte_lines.quantity quantity ,
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

Line 149: ASO_QUOTE_LINES_ALL qte_line

145: Cursor c_relationship Is
146: (SELECT rel.quote_line_id ,
147: rel.related_quote_line_id
148: FROM ASO_LINE_RELATIONSHIPS rel,
149: ASO_QUOTE_LINES_ALL qte_line
150: WHERE qte_line.quote_header_id = p_quote_header_id
151: AND qte_line.quote_line_id = rel.quote_line_id );
152:
153: BEGIN