DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_UTIL dependencies on MTL_PARAMETERS

Line 2681: FROM mtl_parameters

2677: --Getting the master_organization_id for the Inventory Org Id.
2678: BEGIN
2679: SELECT master_organization_id
2680: INTO l_master_org
2681: FROM mtl_parameters
2682: WHERE organization_id = QP_UTIL.Get_Item_Validation_Org;
2683: END;
2684:
2685: --Per M. Antyakula of INV team specifying master org filter as well in

Line 2732: FROM mtl_parameters

2728: --Getting the master_organization_id for the Inventory Org Id.
2729: BEGIN
2730: SELECT master_organization_id
2731: INTO l_master_org
2732: FROM mtl_parameters
2733: WHERE organization_id = QP_UTIL.Get_Item_Validation_Org;
2734: END;
2735:
2736: --Per M. Antyakula of INV team specifying master org filter as well in

Line 3088: FROM MTL_PARAMETERS

3084: AND i.customer_item_number = p_item_number_cust
3085: AND i.Customer_Item_Id = x.customer_item_id
3086: AND x.Master_Organization_Id =
3087: (SELECT Master_Organization_Id
3088: FROM MTL_PARAMETERS
3089: WHERE Organization_Id = p_org_id)
3090: ORDER BY Preference_Number ASC)
3091: WHERE rownum = 1;
3092: EXCEPTION