DBA Data[Home] [Help]

APPS.ASO_UTILITY_PVT dependencies on ASO_QUOTE_LINES_ALL

Line 3362: FROM ASO_QUOTE_LINES_ALL

3358: l_qte_line_rec.OBJECT_VERSION_NUMBER,
3359: l_qte_line_rec.PRICING_QUANTITY_UOM,
3360: l_qte_line_rec.PRICING_QUANTITY,
3361: l_qte_line_rec.CONFIG_MODEL_TYPE
3362: FROM ASO_QUOTE_LINES_ALL
3363: WHERE quote_line_id = p_qte_line_id;
3364: RETURN l_qte_line_rec;
3365: EXCEPTION
3366: WHEN NO_DATA_FOUND THEN

Line 3466: FROM ASO_Quote_Lines_All

3462: PRICING_QUANTITY_UOM,
3463: PRICING_QUANTITY,
3464: CONFIG_MODEL_TYPE
3465:
3466: FROM ASO_Quote_Lines_All
3467: WHERE quote_header_id = p_qte_header_id
3468: ORDER BY Line_Number;
3469: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3470: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 4191: FROM ASO_Quote_Lines_All

4187: CHARGE_PERIODICITY_CODE,
4188: PRICING_QUANTITY_UOM,
4189: PRICING_QUANTITY,
4190: OBJECT_VERSION_NUMBER
4191: FROM ASO_Quote_Lines_All
4192: WHERE quote_header_id = p_qte_header_id
4193: ORDER BY Line_Number;
4194:
4195: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS

Line 4539: FROM ASO_Quote_Lines_All

4535: CHARGE_PERIODICITY_CODE,
4536: PRICING_QUANTITY_UOM,
4537: PRICING_QUANTITY,
4538: OBJECT_VERSION_NUMBER
4539: FROM ASO_Quote_Lines_All
4540: WHERE quote_header_id = p_qte_header_id
4541: AND quote_line_id = p_qte_line_id
4542: ORDER BY Line_Number;
4543: