DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on MTL_SYSTEM_ITEMS_B

Line 5189: FROM mtl_system_items_b

5185: if (p_product_context = 'ITEM')
5186: and (p_product_attribute = 'PRICING_ATTRIBUTE1') THEN
5187: begin
5188: SELECT 'VALID' INTO l_dummy
5189: FROM mtl_system_items_b
5190: where inventory_item_id = p_product_attr_val
5191: AND ((l_appl_id not in (178,201) and customer_order_flag = 'Y')
5192: or (l_appl_id in (178, 201) and NVL(PURCHASING_ENABLED_FLAG, 'N') ='Y'))
5193: and organization_id = Get_Item_Validation_Org;