APPS.ASO_PRICING_CORE_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 272: FROM aso_quote_line_details line_dtl

268:
269: /*Cursor to obtain the top model inventory item id*/
270: CURSOR C_top_model_item_id(p_config_hdr_id NUMBER, p_rev_num NUMBER) IS
271: SELECT qte.inventory_item_id
272: FROM aso_quote_line_details line_dtl
273: ,aso_quote_lines_all qte
274: WHERE qte.quote_line_id = line_dtl.quote_line_id
275: AND line_dtl.config_header_id = p_config_hdr_id
276: AND line_dtl.config_revision_num = p_rev_num

Line 7373: FROM ASO_QUOTE_LINE_DETAILS ldets,

7369: 0,
7370: ldets.quote_line_id related_quote_line_id,
7371: to_number(NULL),
7372: to_number(NULL)
7373: FROM ASO_QUOTE_LINE_DETAILS ldets,
7374: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7375: ASO_QUOTE_LINES_ALL lines
7376: WHERE ldets.quote_line_id = serviceLines.column_value
7377: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id

Line 7402: FROM ASO_QUOTE_LINE_DETAILS ldets,

7398: G_RLTD_RLTD_LINE_DTL_IND_TBL,
7399: G_RLTD_RELATED_LINE_IND_TBL,
7400: G_RLTD_LST_LN_ID_DEF_TBL,
7401: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7402: FROM ASO_QUOTE_LINE_DETAILS ldets,
7403: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7404: ASO_QUOTE_LINES_ALL lines
7405: WHERE ldets.quote_line_id = serviceLines.column_value
7406: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id