[Home] [Help]
64: msi.customer_order_flag CUSTFLAG,
65: msi.eam_item_type EAMTYPE,
66: msi.contract_item_type_code CONTCODE,
67: msi.gdsn_outbound_enabled_flag GDSNFLAG
68: from mtl_parameters mp,
69: mtl_system_items_interface msi
70: where mp.MASTER_ORGANIZATION_ID <> msi.organization_id
71: and mp.organization_id = msi.organization_id
72: AND msi.transaction_type = 'CREATE'
1102: user_id, /* created_by */
1103: login_id /* last_update_login */
1104: from MTL_SYSTEM_ITEMS_INTERFACE I
1105: , FND_LANGUAGES L
1106: , mtl_parameters mp
1107: where I.process_flag = l_process_flag_4
1108: and I.set_process_id = xset_id
1109: and I.transaction_type = l_transaction_type
1110: and L.INSTALLED_FLAG in ('I', 'B')
1159: and I.transaction_type = l_transaction_type
1160: and L.INSTALLED_FLAG in ('I', 'B')
1161: and msitl.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
1162: and msitl.ORGANIZATION_ID = (SELECT Master_Organization_Id
1163: FROM Mtl_Parameters
1164: WHERE Organization_Id = I.Organization_id)
1165: and msitl.Language = l.language_code
1166: and I.ORGANIZATION_ID IN (SELECT Organization_Id
1167: FROM Mtl_Parameters
1163: FROM Mtl_Parameters
1164: WHERE Organization_Id = I.Organization_id)
1165: and msitl.Language = l.language_code
1166: and I.ORGANIZATION_ID IN (SELECT Organization_Id
1167: FROM Mtl_Parameters
1168: WHERE Master_Organization_Id <> Organization_Id);
1169:
1170: FOR cr IN c_ego_intf_rows LOOP
1171: UPDATE MTL_SYSTEM_ITEMS_TL
1187: --
1188: delete from mtl_descr_element_values
1189: where inventory_item_id in
1190: ( select inventory_item_id
1191: from mtl_parameters MP,
1192: MTL_SYSTEM_ITEMS_INTERFACE I
1193: where I.process_flag = l_process_flag_4
1194: and I.set_process_id = xset_id
1195: and I.transaction_type = l_transaction_type
1232: prg_id,
1233: l_sysdate,
1234: MDE.ELEMENT_SEQUENCE
1235: from mtl_descriptive_elements MDE,
1236: mtl_parameters MP,
1237: mtl_system_items_interface I
1238: where I.process_flag = l_process_flag_4
1239: and I.set_process_id = xset_id
1240: and I.transaction_type = l_transaction_type
1602: ,req_id -- request_id
1603: FROM mtl_system_items_interface msi
1604: ,mtl_default_category_sets mdcs
1605: ,mtl_category_sets_b mcs
1606: ,mtl_parameters mp
1607: WHERE
1608: msi.transaction_type = 'CREATE'
1609: AND msi.process_flag = l_process_flag_4
1610: AND msi.set_process_id = xset_id
1610: AND msi.set_process_id = xset_id
1611: AND msi.INVENTORY_ITEM_STATUS_CODE <> 'Pending'
1612: AND mdcs.category_set_id = mcs.category_set_id
1613: AND mp.master_organization_id = (select master_organization_id
1614: FROM mtl_parameters m
1615: where m.organization_id = msi.organization_id)
1616: AND mcs.default_category_id IS NOT NULL
1617: AND
1618: ( -- which all functional areas apply
1727: ** sysdate,
1728: ** msii.organization_id
1729: ** from mtl_system_items_interface msii,
1730: ** mtl_item_categories mic,
1731: ** MTL_PARAMETERS MP
1732: ** where msii.process_flag = 4
1733: ** and msii.transaction_type = 'CREATE'
1734: ** and msii.created_by in (1,2)
1735: ** and mic.organization_id = msii.last_updated_by
1814: ** was used to enhance performance
1815: ** 26SEP95 Removed the following from the statement above
1816: ** This is obsolete since the TWO_PASS design assumes that the master is in
1817: ** Also added the where not exists clause
1818: ** And of course, removed mtl_parameters mp from the FROM clause
1819: **
1820: ** and ((msii.ORGANIZATION_ID = MP.ORGANIZATION_ID) OR
1821: ** ((MP.ORGANIZATION_ID =
1822: ** (select MASTER_ORGANIZATION_ID
1819: **
1820: ** and ((msii.ORGANIZATION_ID = MP.ORGANIZATION_ID) OR
1821: ** ((MP.ORGANIZATION_ID =
1822: ** (select MASTER_ORGANIZATION_ID
1823: ** from MTL_PARAMETERS MP
1824: ** where msii.ORGANIZATION_ID = MP.ORGANIZATION_ID)) and
1825: ** msii.created_by = 0))
1826: **
1827: ** Finally moved it all into a cursor UOM_process so that individual rows