APPS.INVUPD2B dependencies on MTL_PARAMETERS

Line 352: from MTL_PARAMETERS

348: AND set_process_id = xset_id
349: AND ( (organization_id = org_id) or (all_org = 1) )
350: AND organization_id IN
351: ( select organization_id
352: from MTL_PARAMETERS
353: where organization_id = master_organization_id
354: )
355: AND not exists
356: (select 1 from mtl_system_items_interface

Line 1465: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1461: CURSOR C_msi_child_records is
1462: select
1463: MSI.INVENTORY_ITEM_ID,
1464: MSI.ORGANIZATION_ID
1465: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1466: where MP.master_organization_id = org_id
1467: and MP.organization_id = MSI.organization_id
1468: and MSI.inventory_item_id = inv_item_id
1469: and MSI.organization_id <> MP.master_organization_id;

Line 3495: from MTL_PARAMETERS MP

3491: and set_process_id = xset_id
3492: and ((organization_id = org_id) or (all_org = 1))
3493: and organization_id in
3494: (select organization_id
3495: from MTL_PARAMETERS MP
3496: where MP.organization_id <> MP.master_organization_id);
3497:
3498: ret_code_update NUMBER := 1;
3499:

Line 3659: from MTL_PARAMETERS

3655: and msi.inventory_item_id = msii_temp.inventory_item_id ;
3656:
3657: select master_organization_id
3658: into morgid
3659: from MTL_PARAMETERS
3660: where organization_id = msii_temp.organization_id;
3661:
3662: -- Start : 6531911
3663: IF msi_temp.lot_control_code <> msii_temp.lot_control_code THEN

Line 5766: mtl_parameters mp

5762: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5763: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5764: FROM mtl_system_items_b_kfv msik,
5765: mtl_system_items_interface msii,
5766: mtl_parameters mp
5767: WHERE msii.set_process_id = xset_id
5768: AND msii.transaction_type = 'UPDATE'
5769: AND msii.process_flag = 4
5770: AND msii.organization_id = mp.master_organization_id

Line 6207: mtl_parameters mp

6203: sysdate,
6204: -1,
6205: mp.organization_id
6206: from mtl_category_sets s,
6207: mtl_parameters mp
6208: where mp.master_organization_id = (select master_organization_id
6209: FROM mtl_parameters m
6210: where m.organization_id = rec.organization_id)
6211: and mp.organization_id <> mp.master_organization_id

Line 6209: FROM mtl_parameters m

6205: mp.organization_id
6206: from mtl_category_sets s,
6207: mtl_parameters mp
6208: where mp.master_organization_id = (select master_organization_id
6209: FROM mtl_parameters m
6210: where m.organization_id = rec.organization_id)
6211: and mp.organization_id <> mp.master_organization_id
6212: and s.default_category_id IS NOT NULL --Bug: 2801594
6213: and s.category_set_id in

Line 6233: -- pick up rows from mtl_parameters table

6229: ( select 'already_exists'
6230: from mtl_item_categories mic
6231: where mic.inventory_item_id = rec.inventory_item_id
6232: --Bug 4089984. Modified following 'and' condition to
6233: -- pick up rows from mtl_parameters table
6234: and mic.organization_id = mp.organization_id
6235: and mic.category_set_id = s.category_set_id
6236: )
6237: and (exists

Line 6304: -- pick up rows from mtl_parameters table

6300: ( select 'already_exists'
6301: from mtl_item_categories mic
6302: where mic.inventory_item_id = rec.inventory_item_id
6303: --Bug 4089984. Modified following 'and' condition to
6304: -- pick up rows from mtl_parameters table
6305: and mic.organization_id = rec.organization_id
6306: and mic.category_set_id = s.category_set_id
6307: );
6308: /*end of bug 9833451*/

Line 6322: from mtl_parameters MP

6318: inventory_item_id = rec.inventory_item_id
6319: and rec.item_catalog_group_id is not null
6320: and exists
6321: ( select 'x'
6322: from mtl_parameters MP
6323: where MP.organization_id = rec.organization_id
6324: and MP.master_organization_id = rec.organization_id
6325: );
6326:

Line 6359: , mtl_parameters MP

6355: l_sysdate,
6356: MDE.ELEMENT_SEQUENCE
6357: from
6358: mtl_descriptive_elements MDE
6359: , mtl_parameters MP
6360: where
6361: rec.organization_id = MP.master_organization_id
6362: and rec.organization_id = MP.organization_id
6363: and MDE.item_catalog_group_id = nvl(rec.item_catalog_group_id,-999);

Line 7373: FROM mtl_parameters p

7369: WHERE d.inventory_item_id = p_itemID
7370: AND EXISTS
7371: (
7372: SELECT 1
7373: FROM mtl_parameters p
7374: WHERE p.master_organization_id = p_orgID
7375: AND d.organization_id = p.organization_id
7376: )
7377: AND EXISTS