APPS.INV_DETAIL_UTIL_PVT dependencies on MTL_PARAMETERS

Line 148: ,mtl_parameters mp

144: ,NVL(msi.end_assembly_pegging_flag,'N')
145: ,mp.allocate_serial_flag
146: FROM mtl_transaction_types mtt
147: ,mtl_system_items msi
148: ,mtl_parameters mp
149: WHERE mtt.transaction_type_id = l_txn_type_id
150: AND msi.inventory_item_id = l_inventory_item_id
151: AND msi.organization_id = l_organization_id
152: AND mp.organization_id = l_organization_id;

Line 1197: -- Bug 1712465 - We now get detail_any_serial from mtl_parameters

1193: -- Determine whether serial numbers should be detailed.
1194: -- First, get value for profile
1195: -- If profile = 1, detail any serial number, not just those
1196: -- within the given range
1197: -- Bug 1712465 - We now get detail_any_serial from mtl_parameters
1198: -- in the get_request_context procedure.
1199: --x_request_context.detail_any_serial :=
1200: -- to_number(fnd_profile.value('INV:DETAIL_SERIAL_NUMBERS'));
1201:

Line 4228: from mtl_parameters

4224: l_organization_code Varchar2(10);
4225:
4226: Cursor get_org (p_organization_id IN NUMBER) is
4227: Select organization_code
4228: from mtl_parameters
4229: Where organization_id = p_organization_id;
4230: Begin
4231: Open get_org(p_organization_id);
4232: Fetch get_org into l_organization_code;