APPS.ASO_PRICING_CORE_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 265: FROM aso_quote_line_details line_dtl

261:
262: /*Cursor to obtain the top model inventory item id*/
263: CURSOR C_top_model_item_id(p_config_hdr_id NUMBER, p_rev_num NUMBER) IS
264: SELECT qte.inventory_item_id
265: FROM aso_quote_line_details line_dtl
266: ,aso_quote_lines_all qte
267: WHERE qte.quote_line_id = line_dtl.quote_line_id
268: AND line_dtl.config_header_id = p_config_hdr_id
269: AND line_dtl.config_revision_num = p_rev_num

Line 7357: FROM ASO_QUOTE_LINE_DETAILS ldets,

7353: 0,
7354: ldets.quote_line_id related_quote_line_id,
7355: to_number(NULL),
7356: to_number(NULL)
7357: FROM ASO_QUOTE_LINE_DETAILS ldets,
7358: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7359: ASO_QUOTE_LINES_ALL lines
7360: WHERE ldets.quote_line_id = serviceLines.column_value
7361: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7386: FROM ASO_QUOTE_LINE_DETAILS ldets,

7382: G_RLTD_RLTD_LINE_DTL_IND_TBL,
7383: G_RLTD_RELATED_LINE_IND_TBL,
7384: G_RLTD_LST_LN_ID_DEF_TBL,
7385: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7386: FROM ASO_QUOTE_LINE_DETAILS ldets,
7387: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7388: ASO_QUOTE_LINES_ALL lines
7389: WHERE ldets.quote_line_id = serviceLines.column_value
7390: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id