APPS.ASO_UTILITY_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 4252: FROM ASO_QUOTE_LINE_DETAILS

4248: ORDER BY Line_Number;
4249:
4250: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS
4251: SELECT service_ref_type_code , service_ref_line_id
4252: FROM ASO_QUOTE_LINE_DETAILS
4253: WHERE quote_line_id = p_qte_line_id;
4254:
4255: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
4256: SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,

Line 4322: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;

4318: /******* Start SUN Changes ER: 3802859 *******/
4319:
4320:
4321: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4322: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4323: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4324:
4325: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4326: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 4323: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;

4319:
4320:
4321: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4322: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4323: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4324:
4325: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4326: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4327: l_service_ref_line_id_tbl Index_Link_Tbl_Type;

Line 4801: FROM ASO_QUOTE_LINE_DETAILS

4797: AND mtl.organization_id = p_organization_id;
4798:
4799: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS
4800: SELECT service_ref_type_code , service_ref_line_id
4801: FROM ASO_QUOTE_LINE_DETAILS
4802: WHERE quote_line_id = p_qte_line_id;
4803:
4804: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
4805: SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,

Line 4873: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;

4869:
4870: /* End bug 13482837 for current quote service reference */
4871:
4872: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4873: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4874: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4875:
4876: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4877: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 4874: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;

4870: /* End bug 13482837 for current quote service reference */
4871:
4872: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4873: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4874: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4875:
4876: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4877: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4878: l_service_ref_line_id_tbl Index_Link_Tbl_Type;

Line 5313: FROM ASO_Quote_Line_Details

5309: COMPONENT_SEQUENCE_ID,
5310: OBJECT_VERSION_NUMBER,
5311: CONFIG_DELTA,
5312: CONFIG_INSTANCE_NAME
5313: FROM ASO_Quote_Line_Details
5314: WHERE quote_line_id = p_qte_line_id;
5315: l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
5316: l_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5317: BEGIN