APPS.CSTPACDP dependencies on MTL_SYSTEM_ITEMS_B

Line 7320: FROM mtl_system_items_b

7316: +----------------------------------------------------------------------*/
7317: l_stmt_num := 160;
7318: select decode(inventory_asset_flag,'Y',0,1), nvl(expense_account, -1)
7319: INTO iexp_flg, exp_acct
7320: FROM mtl_system_items_b
7321: WHERE inventory_item_id = item_id
7322: AND organization_id = org_id;
7323:
7324:

Line 7531: FROM mtl_system_items_b send, mtl_system_items_b rec

7527: +----------------------------------------------------------------------*/
7528: l_stmt_num := 460;
7529: select send.primary_uom_code, rec.primary_uom_code
7530: INTO send_uom, rec_uom
7531: FROM mtl_system_items_b send, mtl_system_items_b rec
7532: WHERE send.inventory_item_id = item_id
7533: AND send.organization_id = from_org
7534: AND rec.inventory_item_id = item_id
7535: AND rec.organization_id = to_org;