DBA Data[Home] [Help]

APPS.CSP_RELATED_ITEMS_PKG dependencies on MTL_PARAMETERS

Line 38: from mtl_parameters mp, mtl_item_attributes mia, mtl_system_items msi

34:
35: cursor c_organizations is
36: select decode(mia.control_level,1,mp.master_organization_id,mp.organization_id)
37: organization_id
38: from mtl_parameters mp, mtl_item_attributes mia, mtl_system_items msi
39: where mp.master_organization_id = p_org_id
40: and mia.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
41: and mp.organization_id = msi.organization_id
42: and msi.inventory_item_id = p_item_id