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 3121: FROM MTL_PARAMETERS

3117: AND i.customer_item_number = p_item_number_cust
3118: AND i.Customer_Item_Id = x.customer_item_id
3119: AND x.Master_Organization_Id =
3120: (SELECT Master_Organization_Id
3121: FROM MTL_PARAMETERS
3122: WHERE Organization_Id = p_org_id)
3123: ORDER BY Preference_Number ASC)
3124: WHERE rownum = 1;
3125: EXCEPTION