[Home] [Help]
65: msi.customer_order_flag CUSTFLAG,
66: msi.eam_item_type EAMTYPE,
67: msi.contract_item_type_code CONTCODE,
68: msi.gdsn_outbound_enabled_flag GDSNFLAG
69: from mtl_parameters mp,
70: mtl_system_items_interface msi
71: where mp.MASTER_ORGANIZATION_ID <> msi.organization_id
72: and mp.organization_id = msi.organization_id
73: AND msi.transaction_type = 'CREATE'
1173: user_id, /* created_by */
1174: login_id /* last_update_login */
1175: from MTL_SYSTEM_ITEMS_INTERFACE I
1176: , FND_LANGUAGES L
1177: , mtl_parameters mp
1178: where I.process_flag = l_process_flag_4
1179: and I.set_process_id = xset_id
1180: and I.transaction_type = l_transaction_type
1181: and L.INSTALLED_FLAG in ('I', 'B')
1233: and I.transaction_type = l_transaction_type
1234: and L.INSTALLED_FLAG in ('I', 'B')
1235: and msitl.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
1236: and msitl.ORGANIZATION_ID = (SELECT Master_Organization_Id
1237: FROM Mtl_Parameters
1238: WHERE Organization_Id = I.Organization_id)
1239: and msitl.Language = l.language_code
1240: and I.ORGANIZATION_ID IN (SELECT Organization_Id
1241: FROM Mtl_Parameters
1237: FROM Mtl_Parameters
1238: WHERE Organization_Id = I.Organization_id)
1239: and msitl.Language = l.language_code
1240: and I.ORGANIZATION_ID IN (SELECT Organization_Id
1241: FROM Mtl_Parameters
1242: WHERE Master_Organization_Id <> Organization_Id);
1243:
1244: FOR cr IN c_ego_intf_rows LOOP
1245: UPDATE MTL_SYSTEM_ITEMS_TL
1261: --
1262: delete from mtl_descr_element_values
1263: where inventory_item_id in
1264: ( select inventory_item_id
1265: from mtl_parameters MP,
1266: MTL_SYSTEM_ITEMS_INTERFACE I
1267: where I.process_flag = l_process_flag_4
1268: and I.set_process_id = xset_id
1269: and I.transaction_type = l_transaction_type
1308: prg_id,
1309: l_sysdate,
1310: MDE.ELEMENT_SEQUENCE
1311: from mtl_descriptive_elements MDE,
1312: mtl_parameters MP,
1313: mtl_system_items_interface I
1314: where I.process_flag = l_process_flag_4
1315: and I.set_process_id = xset_id
1316: and I.transaction_type = l_transaction_type
1688: ,req_id -- request_id
1689: FROM mtl_system_items_interface msi
1690: ,mtl_default_category_sets mdcs
1691: ,mtl_category_sets_b mcs
1692: ,mtl_parameters mp
1693: WHERE
1694: msi.transaction_type = 'CREATE'
1695: AND msi.process_flag = l_process_flag_4
1696: AND msi.set_process_id = xset_id
1696: AND msi.set_process_id = xset_id
1697: AND msi.INVENTORY_ITEM_STATUS_CODE <> 'Pending'
1698: AND mdcs.category_set_id = mcs.category_set_id
1699: AND mp.master_organization_id = (select master_organization_id
1700: FROM mtl_parameters m
1701: where m.organization_id = msi.organization_id)
1702: AND mcs.default_category_id IS NOT NULL
1703: AND
1704: ( -- which all functional areas apply
1813: ** sysdate,
1814: ** msii.organization_id
1815: ** from mtl_system_items_interface msii,
1816: ** mtl_item_categories mic,
1817: ** MTL_PARAMETERS MP
1818: ** where msii.process_flag = 4
1819: ** and msii.transaction_type = 'CREATE'
1820: ** and msii.created_by in (1,2)
1821: ** and mic.organization_id = msii.last_updated_by
1900: ** was used to enhance performance
1901: ** 26SEP95 Removed the following from the statement above
1902: ** This is obsolete since the TWO_PASS design assumes that the master is in
1903: ** Also added the where not exists clause
1904: ** And of course, removed mtl_parameters mp from the FROM clause
1905: **
1906: ** and ((msii.ORGANIZATION_ID = MP.ORGANIZATION_ID) OR
1907: ** ((MP.ORGANIZATION_ID =
1908: ** (select MASTER_ORGANIZATION_ID
1905: **
1906: ** and ((msii.ORGANIZATION_ID = MP.ORGANIZATION_ID) OR
1907: ** ((MP.ORGANIZATION_ID =
1908: ** (select MASTER_ORGANIZATION_ID
1909: ** from MTL_PARAMETERS MP
1910: ** where msii.ORGANIZATION_ID = MP.ORGANIZATION_ID)) and
1911: ** msii.created_by = 0))
1912: **
1913: ** Finally moved it all into a cursor UOM_process so that individual rows