APPS.ASO_UTILITY_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 4197: FROM ASO_QUOTE_LINE_DETAILS

4193: ORDER BY Line_Number;
4194:
4195: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS
4196: SELECT service_ref_type_code , service_ref_line_id
4197: FROM ASO_QUOTE_LINE_DETAILS
4198: WHERE quote_line_id = p_qte_line_id;
4199:
4200: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
4201: SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,

Line 4219: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;

4215: WHERE customer_product_id = p_instance_id
4216: AND account_id = p_cust_account_id;
4217:
4218: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4219: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4220: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4221:
4222: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4223: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 4220: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;

4216: AND account_id = p_cust_account_id;
4217:
4218: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4219: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4220: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4221:
4222: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4223: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4224: l_service_ref_line_id_tbl Index_Link_Tbl_Type;

Line 4555: FROM ASO_QUOTE_LINE_DETAILS

4551: AND mtl.organization_id = p_organization_id;
4552:
4553: CURSOR c_Qte_Line_SVC_ref(p_qte_line_id IN NUMBER) IS
4554: SELECT service_ref_type_code , service_ref_line_id
4555: FROM ASO_QUOTE_LINE_DETAILS
4556: WHERE quote_line_id = p_qte_line_id;
4557:
4558: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
4559: SELECT line_id, inventory_item_id, pricing_quantity, pricing_quantity_uom,

Line 4577: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;

4573: WHERE customer_product_id = p_instance_id
4574: AND account_id = p_cust_account_id;
4575:
4576: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4577: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4578: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4579:
4580: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4581: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 4578: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;

4574: AND account_id = p_cust_account_id;
4575:
4576: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;
4577: l_ref_type_code ASO_QUOTE_LINE_DETAILS.SERVICE_REF_TYPE_CODE%TYPE;
4578: l_service_ref_line_id ASO_QUOTE_LINE_DETAILS.SERVICE_REF_LINE_ID%TYPE;
4579:
4580: l_Qte_Line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4581: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4582: l_service_ref_line_id_tbl Index_Link_Tbl_Type;

Line 4862: FROM ASO_Quote_Line_Details

4858: COMPONENT_SEQUENCE_ID,
4859: OBJECT_VERSION_NUMBER,
4860: CONFIG_DELTA,
4861: CONFIG_INSTANCE_NAME
4862: FROM ASO_Quote_Line_Details
4863: WHERE quote_line_id = p_qte_line_id;
4864: l_Line_Dtl_rec ASO_QUOTE_PUB.Qte_Line_Dtl_Rec_Type;
4865: l_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4866: BEGIN