APPS.ASO_UTILITY_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 4308: FROM csi_instance_accts_rg_v a ,mtl_system_items_vl b

4304: AND si.organization_id = cii.inv_master_organization_id
4305: AND cii.instance_id =p_instance_id;
4306:
4307: /* SELECT distinct a.product,b.inventory_item_id,a.quantity,a.unit_of_measure_code
4308: FROM csi_instance_accts_rg_v a ,mtl_system_items_vl b
4309: where a.product = b.concatenated_segments
4310: AND a.customer_product_id = p_instance_id;
4311: --AND a.account_id = p_cust_account_id;
4312: */

Line 4321: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;

4317:
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;

Line 4872: l_service_item_flag MTL_SYSTEM_ITEMS_VL.SERVICE_ITEM_FLAG%TYPE;

4868: where quote_line_id=p_quote_line_id;
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;