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 239: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'

235: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.MTL_TRANSACTIONS_ENABLED_FLAG'
236: AND NVL(rec.MTL_TRANSACTIONS_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
237: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.PURCHASING_ENABLED_FLAG'
238: AND NVL(rec.PURCHASING_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
239: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BUILD_IN_WIP_FLAG'
240: AND NVL(rec.BUILD_IN_WIP_FLAG,srec.attribute_value) <> srec.attribute_value)
241: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
242: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
243: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'

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

241: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_ENABLED_FLAG'
242: AND NVL(rec.CUSTOMER_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
243: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_ENABLED_FLAG'
244: AND NVL(rec.INTERNAL_ORDER_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
245: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.BOM_ENABLED_FLAG'
246: AND NVL(rec.BOM_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
247: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.INVOICE_ENABLED_FLAG'
248: AND NVL(rec.INVOICE_ENABLED_FLAG,srec.attribute_value) <> srec.attribute_value)
249: OR (srec.attribute_name = 'MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG'

Line 1222: from MTL_SYSTEM_ITEMS_B MSI

1218: and MSII.set_process_id = xset_id
1219: and MSII.process_flag = 1
1220: and not exists
1221: (select inventory_item_id
1222: from MTL_SYSTEM_ITEMS_B MSI
1223: where MSII.inventory_item_id = MSI.inventory_item_id
1224: and MSII.organization_id = MSI.organization_id)
1225: for update;
1226:

Line 1320: from mtl_system_items_B msi,

1316: if inv_item_id is null then -- {
1317:
1318: dummy_ret_code := INVPUTLI.get_dynamic_sql_str(1, statement_temp, err_temp);
1319: DSQL_statement := 'select msi.inventory_item_id
1320: from mtl_system_items_B msi,
1321: mtl_system_items_interface msii
1322: where msii.rowid = :row_id_bind
1323: AND msi.organization_id = msii.organization_id
1324: and ' || statement_temp;

Line 1350: from MTL_SYSTEM_ITEMS_B

1346: end if; -- }
1347:
1348: select organization_id
1349: into tmp_orgid
1350: from MTL_SYSTEM_ITEMS_B
1351: where organization_id = org_id
1352: and inventory_item_id = inv_item_id;
1353:
1354: return (1);

Line 1446: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1442: CURSOR C_child_msi_records IS
1443: select
1444: MSI.INVENTORY_ITEM_ID,
1445: MSI.ORGANIZATION_ID
1446: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1447: where MP.master_organization_id = org_id
1448: and MP.organization_id = MSI.organization_id
1449: and MSI.inventory_item_id = inv_item_id
1450: and MSI.organization_id <> MP.master_organization_id;