DBA Data[Home] [Help]

APPS.MTL_PARAM_VALIDATE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 12: from mtl_system_items i

8: v_garbage VARCHAR(255);
9: BEGIN
10: select 'x'
11: into v_garbage
12: from mtl_system_items i
13: where i.organization_id =
14: curr_org_id
15: and not exists (select 'x'
16: from mtl_system_items i2

Line 16: from mtl_system_items i2

12: from mtl_system_items i
13: where i.organization_id =
14: curr_org_id
15: and not exists (select 'x'
16: from mtl_system_items i2
17: where i2.organization_id =
18: master_org_id
19: and i2.inventory_item_id =
20: i.inventory_item_id)

Line 112: from mtl_system_items_b

108: cursor ser_config(p_org_id number) is
109: select serial_number,count(*)
110: from mtl_serial_numbers
111: where inventory_item_id in (select inventory_item_id
112: from mtl_system_items_b
113: where organization_id = p_org_id
114: and serial_number_control_code <> 1
115: and base_item_id is not null
116: and bom_item_type = 4)