APPS.INVUPD2B dependencies on MTL_PARAMETERS

Line 350: from MTL_PARAMETERS

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

Line 1434: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1430: CURSOR C_msi_child_records is
1431: select
1432: MSI.INVENTORY_ITEM_ID,
1433: MSI.ORGANIZATION_ID
1434: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1435: where MP.master_organization_id = org_id
1436: and MP.organization_id = MSI.organization_id
1437: and MSI.inventory_item_id = inv_item_id
1438: and MSI.organization_id <> MP.master_organization_id;

Line 3442: from MTL_PARAMETERS MP

3438: and set_process_id = xset_id
3439: and ((organization_id = org_id) or (all_org = 1))
3440: and organization_id in
3441: (select organization_id
3442: from MTL_PARAMETERS MP
3443: where MP.organization_id <> MP.master_organization_id);
3444:
3445: ret_code_update NUMBER := 1;
3446:

Line 3602: from MTL_PARAMETERS

3598: and msi.inventory_item_id = msii_temp.inventory_item_id ;
3599:
3600: select master_organization_id
3601: into morgid
3602: from MTL_PARAMETERS
3603: where organization_id = msii_temp.organization_id;
3604:
3605: -- Start : 6531911
3606: IF msi_temp.lot_control_code <> msii_temp.lot_control_code THEN

Line 5520: mtl_parameters mp

5516: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5517: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5518: FROM mtl_system_items_b_kfv msik,
5519: mtl_system_items_interface msii,
5520: mtl_parameters mp
5521: WHERE msii.set_process_id = xset_id
5522: AND msii.transaction_type = 'UPDATE'
5523: AND msii.process_flag = 4
5524: AND msii.organization_id = mp.master_organization_id

Line 5876: , mtl_parameters p

5872: sysdate,
5873: -1,
5874: p.organization_id
5875: from mtl_category_sets s
5876: , mtl_parameters p
5877: where
5878: p.master_organization_id =
5879: (select master_organization_id
5880: from mtl_parameters

Line 5880: from mtl_parameters

5876: , mtl_parameters p
5877: where
5878: p.master_organization_id =
5879: (select master_organization_id
5880: from mtl_parameters
5881: where organization_id = rec.organization_id
5882: )
5883: AND s.default_category_id IS NOT NULL --Bug: 2801594
5884: and s.category_set_id in

Line 5904: -- pick up rows from mtl_parameters table

5900: ( select 'already_exists'
5901: from mtl_item_categories mic
5902: where mic.inventory_item_id = rec.inventory_item_id
5903: --Bug 4089984. Modified following 'and' condition to
5904: -- pick up rows from mtl_parameters table
5905: and mic.organization_id = p.organization_id
5906: and mic.category_set_id = s.category_set_id
5907: );
5908: END IF;

Line 5920: from mtl_parameters MP

5916: inventory_item_id = rec.inventory_item_id
5917: and rec.item_catalog_group_id is not null
5918: and exists
5919: ( select 'x'
5920: from mtl_parameters MP
5921: where MP.organization_id = rec.organization_id
5922: and MP.master_organization_id = rec.organization_id
5923: );
5924:

Line 5957: , mtl_parameters MP

5953: l_sysdate,
5954: MDE.ELEMENT_SEQUENCE
5955: from
5956: mtl_descriptive_elements MDE
5957: , mtl_parameters MP
5958: where
5959: rec.organization_id = MP.master_organization_id
5960: and rec.organization_id = MP.organization_id
5961: and MDE.item_catalog_group_id = nvl(rec.item_catalog_group_id,-999);