APPS.INVUPD1B dependencies on MTL_SYSTEM_ITEMS_B

Line 166: FROM mtl_system_items_B msi

162: msi_secondary_default_ind,
163: msi_ont_pricing_qty_source,
164: msi_dual_uom_deviation_high,
165: msi_dual_uom_deviation_low
166: FROM mtl_system_items_B msi
167: WHERE msi.inventory_item_id = t_inventory_item_id
168: AND msi.organization_id = t_organization_id;
169: EXCEPTION
170: WHEN NO_DATA_FOUND THEN

Line 223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'

219: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
220: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
221: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
222: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
223: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
224: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
226: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'

Line 229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'

225: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
226: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
227: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
228: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
229: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
230: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
231: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
232: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
233: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'

Line 1206: from MTL_SYSTEM_ITEMS_B MSI

1202: and MSII.set_process_id = xset_id
1203: and MSII.process_flag = 1
1204: and not exists
1205: (select inventory_item_id
1206: from MTL_SYSTEM_ITEMS_B MSI
1207: where MSII.inventory_item_id = MSI.inventory_item_id
1208: and MSII.organization_id = MSI.organization_id)
1209: for update;
1210:

Line 1304: from mtl_system_items_B msi,

1300: if inv_item_id is null then -- {
1301:
1302: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, statement_temp, err_temp);
1303: DSQL_statement := 'select msi.inventory_item_id
1304: from mtl_system_items_B msi,
1305: mtl_system_items_interface msii
1306: where msii.rowid = :row_id_bind
1307: AND msi.organization_id = msii.organization_id
1308: and ' || statement_temp;

Line 1334: from MTL_SYSTEM_ITEMS_B

1330: end if; -- }
1331:
1332: select organization_id
1333: into tmp_orgid
1334: from MTL_SYSTEM_ITEMS_B
1335: where organization_id = org_id
1336: and inventory_item_id = inv_item_id;
1337:
1338: return (1);

Line 1430: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1426: CURSOR C_child_msi_records IS
1427: select
1428: MSI.INVENTORY_ITEM_ID,
1429: MSI.ORGANIZATION_ID
1430: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1431: where MP.master_organization_id = org_id
1432: and MP.organization_id = MSI.organization_id
1433: and MSI.inventory_item_id = inv_item_id
1434: and MSI.organization_id <> MP.master_organization_id;